Writing a query statement for dates

Question

Writing a query statement for dates

shenlingstyle (Electrical)

(OP)

14 Dec 05 14:31

Hi, I'm a beginner in writing SQL statements.

Well basically I have a database with a date field. The data shows up like "11/23/2003 1:11:00 AM". The field is called START_DATE.

How can I write a query statement to extract all records that refer to tomorrow, December 15th, 2005?

Thanks all any help,

Colin

rtmpxr (Nuclear) · Answer 1 · 2005-12-15 03:13:11

It depends what features your SQL engine has. This is an example which works on Firebird SQL engine:

select START_DATE from <your table> where CAST(START_DATE as DATE)=CURRENT_DATE+1

Here CURRENT_DATE is a function which return the current date from computer.

shenlingstyle (Electrical) · Answer 2 · 2005-12-16 09:07:09

RE: Writing a query statement for dates

shenlingstyle (Electrical)

(OP)

16 Dec 05 09:07

Thanks a bunch.

johnwm (Computer) · Answer 3 · 2005-12-16 17:51:38

Many SQL dialects have a Between operator which is useful foe handling Dates and DateTime values

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

Steam Engine enthusiasts: www.essexsteam.co.uk

Come Join Us!

Posting Guidelines

Writing a query statement for dates