Just use the date() function, i.e. date(timestamp). Paul Knowles

-----Original Message-----
From: Sheth Jignesh
[mailto:db2udbdba-ezmlmshield-x10646643.[Email address protected]
Sent: Monday, April 25, 2005 12:40 PM
To: LazyDBA Discussion
Subject: Timestamp conversion


Hi,

I have a timestamp field which returns the value as 2005-04-22 11:50:48
I need the value to be converted to date field like 2005-04-22
Is there any db2 function I can use for that ???


Thanks.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page