Re: help: adding an hour to a DATE datatype...

From: ccrissma_at_ucs.att.com <(ccrissma_at_ucs.att.com)>
Date: 1995/09/28
Message-ID: <1995Sep28.102753.19970_at_ucseng.ucs.att.com>#1/1

Oracle interprets number constants in arithmetic date expressions as numbers of days. For example, SYSDATE + 1 is tomorrow. SYSDATE - 7 is 1 week ago. SYSDATE + (10/1440) is ten minutes from now. SYSDATE + (n/24) is n hours from now.

You cannot multiply or divide date values.

You can do this with any date.

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Charlie Crissman - ccrissma_at_ucs.att.com
AT&T Universal Card Services - Database Administration
(904) 954-8159

Received on Thu Sep 28 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Alvin W. Law: "Re: Pipe some stuff to SQLPLUS"
Previous message: Mike Philippens: "Re: Q: What did I miss in sys.dba_tables?"
Maybe in reply to: C.J. Jardine: "Re: help: adding an hour to a DATE datatype..."
Next in thread: Alvin W. Law: "Re: Pipe some stuff to SQLPLUS"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message