What are the challenges you face when working across database platforms? Take the survey
Options

Day of year from datetime column

TOftringTOftring Posts: 10
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
Sign In or Register to comment.