Day of year from datetime column

The simplest way to populate your database with test data.

Day of year from datetime column

Postby TOftring » Wed Mar 03, 2010 9:02 am


i have the following problem. In the testtable to fill there is a datetime column where i can create data without a problem. The problem is that i have a second column that need to get the day of year according to the value from the datetime column.

Is there any way to do this.

Posts: 6
Joined: Tue Jul 17, 2007 8:21 am

Postby Anu Deshpande » Thu Mar 04, 2010 12:15 pm

Many thanks for your post.

The feature you are looking for is already logged in our internal tracking system whose tracking id is SDG-765 our developers are looking into this.

I have added your comments to it and will update you as soon as it is fixed.

If you are a programmer we have few suggestions in our knowledge base article where you can accomplish the desired functionality by adding some logic.

Link for that article is : ... rticle=697

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests