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 Deshpande]

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/article.aspx?article=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