Hey,
Im new at Oracle and had some question regarding how the Date to time conversions takes place.I have a table with data fields defined as
| COLUMN NAME | DATA TYPE | NULLABLEDATA | DEFAULT |
| DT_COMPLETED | DATE | Yes | NULL |
| DT_RECEIVED | DATE | Yes | NULL |
If I do a select then I get result in the following format:
16-JAN-01
30-JAN-01
05-MAR-01
Ques : Does the DATE type save time values as well even though I do not see them in the select result?
If i run the following query
SELECT DT_RECEIVED, TO_CHAR(DT_RECEIVED,'HH24:MI:SS')
FROM
TABLEX
I get the following result:
| 16-JAN-01 | 13:37:00 |
| 30-JAN-01 | 15:28:00 |
| 05-MAR-01 | 13:49:00 |
QUES:If the same query returns the following data set, does the 00:00:00 mean 12:00:00 am ??
| 20-SEP-15 | 00:00:00 |
| 20-SEP-15 | 00:00:00 |