Hi, I would like to make a select on a timestamp field in a table and format it in a certain way. The table is: create table my_table (col_timestamp timestamp)
If you do a select (e.g. select col_timestamp from my_table) you get something like '2003-03-18 12:40:57.683825', depending on your system settings. However, I need something like '18.03.2003 12:40'. What I did was: select col_timestamp, LFILL(chr(day(col_timestamp)),'0',2) & '.' & LFILL(chr(month(col_timestamp)),'0',2) & '.' & chr(year(col_timestamp)) & LFILL(chr(hour(col_timestamp)),'0',2) & ':' & LFILL(chr(minute(col_timestamp)),'0',2) as my_time from my_table This works but it seems kind of clumsy to me. Is there a better way to do this?? Thanks, Marco _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
