OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql statement [message #8415]

Tue, 19 August 2003 09:05

Tricia
Messages: 1
Registered: August 2003

Junior Member

I need to select from a table where log_time is between 07/12/2000 15:13:44 and 07/12/2000 15:16:49
How can compose my sql statement to include the seconds

Report message to a moderator

Re: sql statement [message #8416 is a reply to message #8415]

Tue, 19 August 2003 09:23

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

_{quote from Tricia:}
----------------------------------------------------------------------

I need to select from a table where log_time is between 07/12/2000 15:13:44 and 07/12/2000 15:16:49
How can compose my sql statement to include the seconds

----------------------------------------------------------------------

SELECT   *
FROM     table_1          t1
WHERE    t1.log_time BETWEEN TO_DATE('07/12/2000 15:13:44','MM/DD/YYYY HH24:MI:SS')
                         AND TO_DATE('07/12/2000 15:16:49','MM/DD/YYYY HH24:MI:SS')

HTH,

Art.

Report message to a moderator

Previous Topic:	Creating a table parameter in OO4O and VB
Next Topic:	Copy Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 03:36:17 CDT 2024