Day of year from datetime column

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Day of year from datetime column

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

Hello,

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.

Thanks
Thomas
TOftring
 
Posts: 6
Joined: Tue Jul 17, 2007 9:21 am

Postby Anu Deshpande » Thu Mar 04, 2010 1: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 : http://www.simple-talk.com/content/arti ... 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.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests