db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Binu Andrews" <andre...@mahindrabt.com>
Subject date conversion
Date Wed, 25 Jan 2006 13:17:16 GMT

hi all,
 
i want to know wether there is any function for converting date which is
given in millisecond format to a date in proper format.
 
 
eg:- select min(start_date) from message;  ------>          is returning
"138015151844".
 
i want to convert the result into a format like "2006-01-25 18:33:38.537".
 
i dont want to convert to this format using java coding.
im checking for any built in functions provided by derby.
 
 
 
 
 
Thanks in advance
Binu Andrews. 

 


*********************************************************
Disclaimer:    
The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if
any) are privileged and confidential material of MBT and should not be disclosed to, used
by or copied in any manner by anyone other than the intended addressee(s).   In case you are
not the desired addressee, you should delete this message and/or re-direct it to the sender.
 The views expressed in this E-mail message (including the enclosure(s) or attachment(s) if
any) are those of the individual sender, except where the sender expressly, and with authority,
states them to be the views of MBT.

This e-mail message including attachment/(s), if any, is believed to be free of any virus.
 However, it is the responsibility of the recipient to ensure that it is virus free and MBT
is not responsible for any loss or damage arising in any way from its use
      
********************************************************
Mime
View raw message