If your DB is SQL, then use this function:-
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER function [dbo].[fn_Convert_Date_HMS](@i int) returns datetime as begin return (Select DATEADD(second, @i+19800,'19700101')) end Thanks & Regards, Rambabu Rudra System Administrator _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, April 06, 2010 7:29 AM To: arslist@ARSLIST.ORG Subject: How to display DATE field in date format (from DB) 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"