date formart

• sahana

  SSCrazy

  Points: 2530

  More actions

  August 30, 2004 at 9:56 am

  #152279

  The date is stored in my DB as a numeric 9(18,9) data type .How can i convert that value into regular data type

  HEre are the two dates in my DB.How can i change this into regular data formart.

  37774.98856

  37728.38941

  Thanks.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  August 30, 2004 at 12:40 pm

  #521100

  Wow! That's a strange way to keep dates and times.  First you have to tell us how to interpret the datetime value you have as a decimal. In other words, what is the date and time value for each of these:

  37774.98856

  37728.38941

  -SQLBill

• Jean-Pierre PONS

  SSC-Addicted

  Points: 497

  More actions

  August 31, 2004 at 1:27 am

  #521162

  Hi,

  if your rule is as the system datetime format,  (i.e. integer part = date and decimal part = nb secondes since 00:00), you can just use :

  select cast(37774.98856 as datetime) as test1 , cast(37728.38941 as datetime) as test2

  which will give :

  test1                      test2                                         

  -------------------------  ------------------------------------------------------

  2003-06-04 23:43:31.583    2003-04-19 09:20:45.023

  bye.