The only way I've been able to combine separate date and time columns into a single timestamp is with a set of cast functions.
e.g. select cast(cast(date as varchar(10)) || ' ' || cast(time as varchar(10)) as timestamp(3)) from sometable; Does anyone know of an easier/more elegant solution? ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
