Hi,I have a timestamp field which returns the value as 2005-04-22 11:50:48I need the value to be converted to date field like 2005-04-22Is there any db2 function I can use for that ???Thanks.DB2 & UDB email list listserv db2-l LazyDBA home page