Skip to Content
0
Former Member
Dec 12, 2006 at 07:25 AM

to convert field of format DEC (15) date time stamp in database to DAT(10)

1871 Views

Hi

To convert field of format DEC (15) date time stamp in database to DAT(10) in format yyyy-mm-dd.

date is coming in format of date time stamp for eg 20,060,127,200,000 ie 27/01/2006 12:00:00 ( ie the time stamp) so do we need to display date only in format yyyy-mm-dd and remove the time stamp?

pls suggest

regards

Arora