Re: help: adding an hour to a DATE datatype...
From: Mike Morgan <mike.morgan_at_teldta.com>
Date: 1995/09/27
Message-ID: <44c013$pdb_at_madison.tdsnet.com>#1/1
Received on Wed Sep 27 1995 - 00:00:00 CET
Date: 1995/09/27
Message-ID: <44c013$pdb_at_madison.tdsnet.com>#1/1
Craig,
Since Oracle dates are presented as "days" or fractions thereof, to add N hours to a datefield simply SELECT datefield+(N/24) from TABLE.
Mike Morgan
Technology Integration Services - Unix DBA
email: mike.morgan_at_teldta.com
TDS Computing Services
301 S. Westfield Road
Madison, WI 53705 USA
(608)845-4661
"Murphy's Law of computing: Anything that can go wrSegmentation fault(coredump)"
Received on Wed Sep 27 1995 - 00:00:00 CET