Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TIMESTAMP datatype. Anyone using them?

RE: TIMESTAMP datatype. Anyone using them?

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 1 Aug 2005 21:33:44 +0200
Message-Id: <20050801193346.6D1F21D9198@turing.freelists.org>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lex de Haan
Sent: Monday, August 01, 2005 21:19
To: JHostetter_at_decommunications.com; oracle-l_at_freelists.org 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.


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 01 2005 - 14:35:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US