CODEWITHSUNDEEP
databaseoracle-databaseoracle11goracle-sqldeveloper
Alex
Alex

Reputation: 25

Date and Time in SQL Developer

I have 2 tables, 1 table has a date column, 1 table has a time column. I want to have date and time works seperatedly. This is what i use :
ALTER SESSION SET nls_date_format='dd/mm/yyyy';

I use this for the 1st table and then use this for the 2nd table :
ALTER SESSION SET nls_date_format='hh24:mi';

But it doesn't work right. When i do the select * from it all changes back to hh24:mi type. How can i have date and time seperatedly ?

Upvotes: 0

Views: 559

Answers (1)

JoshuaB
JoshuaB

Reputation: 29

As noted Oracle always has a date and time. If you want to see and use just the date or just the time you could use, for example to only work with the time, TO_CHAR(ColumnA, 'HH24:MI:SS')

Upvotes: 1

Related Questions