RE: TIMESTAMP datatype. Anyone using them?
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <lex.de.haan@xxxxxxxxxxxxxx>, <JHostetter@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Aug 2005 21:33:44 +0200
undskyld - excuses - entschuldigung - pardon - etcetera...
the delimiter character between hours/minutes/seconds in these datetime literals
should be a colon. so this is the right syntax:
select *
from mytable
where delete_timestamp >= timestamp '2005-08-01 08:00:00.00'
and delete_timestamp <= timestamp '2005-08-01 08:01:00.00';
even more readable :-)
kind regards,
Lex.
------------------------------------------------------------------
Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html>
http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Lex de Haan
Sent: Monday, August 01, 2005 21:19
To: JHostetter@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: TIMESTAMP datatype. Anyone using them?
... or alternatively, use timestamp literals:
select *
from mytable
where delete_timestamp >= timestamp '2005-08-01 08.00.00.00000'
and delete_timestamp <= timestamp '2005-08-01 08.01.00.00000';
this is slightly more readable, independent of NLS settings,
and you don't rely on Oracle for implicit datatype conversion.
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
