Converting Julian to Calendar

• Glenn

  SSC Veteran

  Points: 289

  More actions

  November 13, 2006 at 11:55 am

  #367993

  I've read a number of different articles and tried lots of examples but I can't figure this out yet. I need to convert a Julian date to a calendar date within SQL. For the longest time I've been using an extra step with both VB and activex scripts to do the conversion but now I have a situation where I need to do it within my select statement. If I'm returning a number of fields, one of which is a date that looks like "103218" how can I convert this to a mm/dd/yyyy format within the SQL. Thanks.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  November 13, 2006 at 12:39 pm

  #671425

  All you need is covered in the links below the second includes manual converter from the Military and a UDF to do it for you.  Hope this helps.

  http://www.minisolve.com/TipsJulianSQL.htm

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762

   

  Kind regards,
  Gift Peddie