Hi, It's a Sybase DB. But we've figured it out. Thanks!:)
Regards, Kali -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tristan Roppel Sent: Tuesday, 6 April 2010 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: How to display DATE field in date format (from DB) Kali Obsum schrieb: > ** > Hi, > > We have a field of type 'DATE'. It is stored as an integer in DB. Does > anyone know how to display this in Date format? (e.g. are there > functions that we can use?) > > Regards, > Kali > > > NOTICE > > The information contained in this email is confidential. If you are > not the intended recipient, you must not disclose or use the > information in this email in any way. If you received it in error, > please tell us immediately by return email and delete the document. We > do not guarantee the integrity of any e-mails or attached files and > are not responsible for any changes made to them by any other person. > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ Hi, If this is an Oracle DB, you can use Oracle's time functions in PL/SQL function to calculate the date from an integer value. The exact function can i send you later ! Cheers Tristan ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"