How to store only time; not date and time?

by

You could try the INTERVAL DAY TO SECOND data type but it won’t save you any disk space … it is very suitable for this purpose though.

create table t1 (time_of_day interval day (0) to second(0));

insert into t1 values (TO_DSINTERVAL('0 23:59:59'));

select date '2009-05-13'+time_of_day
from   t1;

11 bytes though.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. Search All Fields In All Tables For A Specific Value (Oracle)
  4. Select First Row of Every Group in sql [duplicate]
  5. Oracle: how to UPSERT (update or insert into a table?)
  6. Get top results for each group (in Oracle)
  7. Paging with Oracle
  8. Comparing Dates in Oracle SQL
  9. Oracle Differences between NVL and Coalesce
  10. ORA-12560: TNS:protocol adaptor error
  11. SQL – How to store and navigate hierarchies?
  12. What exactly do quotation marks around the table name do?
  13. Calculating difference between two timestamps in Oracle in milliseconds
  14. How can I get column names from a table in Oracle?
  15. Oracle query to fetch column names
  16. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  17. SQL Error: ORA-01861: literal does not match format string 01861
  18. Determine Oracle null == null
  19. INSERT SELECT statement in Oracle 11G
  20. SELECT INTO using Oracle
  21. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  22. `show create table` equivalent in oracle sql
  23. Does ‘Select’ always order by primary key?
  24. ORA-00972 identifier is too long alias column name
  25. How to use a dynamic parameter in a IN clause of a JPA named query?
  26. Search an Oracle database for tables with specific column names?
  27. How to replace specific values in a oracle database column?
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment