Post reply

Convert Date to Julian Date

  • July 24, 2008 at 6:51 am

    #210426

    I have a table that looks like this:

    BusinessDate DateTime

    JulianDate Int

    In the BusinessDate column I have a about 1000 sequential standard dates. I add the JulianDate column and now need to update that column with the appropriate Julian Date based on the date in the BusinessDate column. Any help would be greatfully appreciated.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

  • July 24, 2008 at 7:19 am

    #847711

    http://www.novicksoftware.com/udfofweek/Vol2/T-SQL-UDF-Vol-2-Num-2-udf_DT_ToJulian.htm

  • July 24, 2008 at 7:41 am

    #847746

    That link was really helpful. Thanks.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply