Day of year from datetime column

TOftring

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

Anu D

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.