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"