Last name: Nightingale SDB Popularity ranking: 1104 This unusual name is of Anglo-Saxon origin, and is a nickname surname for someone with a good, sweet singing voice, from the bird, the nightingale.
You are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.If you issue a. alter session set nls_date_format = 'dd/MON/yyyy hh24:mi:ss'.ou are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.
A good example of a date format that is not recognized by SQL Server is an 8 digit date in MMDDYYYY format, this 8 character date format is not recognized by SQL Server as a date. In order to get the MMDDYYYY date into SQL Server you will need to convert it to a format that SQL Server knows is a date, like 'MM-DD-YYYY'.