Query statement with Julian/Georgian date field

• Frank Cadam-207510

  SSC Journeyman

  Points: 94

  More actions

  April 20, 2006 at 4:38 am

  #103145

  I am doing a simple select statement to retrieve data for a report. The date/time fields are in Georgian/Julian date format.

   

  Can any one advice how I can configure the statement to transform the data.

   

  Date  131204100.0        

  Time 185470208.0

   

  Thanks

  Frank

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  April 20, 2006 at 7:21 am

  #633246

  Can you explain "Georgian" ?

  I always understood Julian dates were YYDDD or YYYYDDD format

  What do the Date & Time values refer to ?

  Far away is close at hand in the images of elsewhere.
  Anon.

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  April 20, 2006 at 9:38 am

  #633303

  Have a look at this:

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1225