Hi all,
In Oracle and SQL server I have a date/time of 01/01/2005 13.24.54. If
I do a select using the date field with a criteria of 01/01/2005 it
will find it just fine. DB2 requires the selection criteria to be in
the format 2005-01-01-13.24.54.000000 or it will not find it.
Is there a configuration parameter that can be set in the DB2 instance
or if there is a pre-SQL command
(like Oracles Alter Session Set NLS_DATE_FORMAT=....)? How would one go
about doing this?
Thanks in advance.
Henry