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.
1 From Oracle SQL Developer's menu go to: Tools Preferences. 2  From the Preferences dialog, select Database NLS from the left panel. 3  From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.ith Oracle SQL Developer 3.2.20.09, i managed to set the custom format for the type DATE this way : YYYY-MM-DD HH24:MI:SS. Note that the following format does not worked for me : DD-MON-RR HH24:MI:SS. As a result, it keeps the default format, without any error.