Try it,
select date('2005-04-22 11:50:48') from sysibm.sysdumm1;
or
select date(colname) from table_name;
with regards,
Jitendra Kumar
-----Original Message-----
From: Sheth Jignesh
[mailto:db2udbdba-ezmlmshield-x10646643.[Email address protected]
Sent: Monday, April 25, 2005 10:10 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