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.
21. /* 1 we add the extended property to provide a description to the dbo.Customer.InsertionDate column 2  */. EXECUTE sys.sp_addextendedproperty 'MS_Description', ' 3 the date at which the row was created', 'schema', 'dbo', 'table', ' 4 Customer', 'column', 'InsertionDate'; -- 5  alternative syntax for SQL 2005.