Board index » delphi » Second attempt: TODAY-function in SQL

Ron Tuijnman

Delphi Developer
 

Second attempt: TODAY-function in SQL


2003-09-24 01:23:40 AM
delphi107
I've searched the helpfiles extensively, but all I get is
EXTRACT, no other DATE-functions.
How can I retrieve the current DATE with SQL?
Thanx,
Ron
 
 
Jeremy Collins

Delphi Developer

2003-09-24 04:41:33 PM

Re:Second attempt: TODAY-function in SQL

Ron Tuijnman writes:
Quote
I've searched the helpfiles extensively, but all I get is
EXTRACT, no other DATE-functions.
How can I retrieve the current DATE with SQL?
It would help to know which database. In SQL-Server it is GETDATE()
IIRC.
--
jc
Remove the -not from email
 
Klaus Edelmann

Delphi Developer

2003-09-24 09:18:17 PM

Re:Second attempt: TODAY-function in SQL

"Jeremy Collins" <XXXX@XXXXX.COM>writes:
Quote
It would help to know which database. In SQL-Server it is GETDATE()
IIRC.
SQL-Server does not seem to be a desktop database (group name!).
 

Ron Tuijnman

Delphi Developer

2003-09-25 01:28:38 AM

Re:Second attempt: TODAY-function in SQL

"Jeremy Collins" <XXXX@XXXXX.COM>schreef in bericht
Quote
Ron Tuijnman writes:

>I've searched the helpfiles extensively, but all I get is
 >EXTRACT, no other DATE-functions.
 >How can I retrieve the current DATE with SQL?
It would help to know which database. In SQL-Server it's
GETDATE()
IIRC.
....Just plain and simple Paradox SQL...
Cu,
Ron
 
Jeremy Collins

Delphi Developer

2003-09-25 03:48:01 PM

Re:Second attempt: TODAY-function in SQL

Ron Tuijnman writes:
Quote
"Jeremy Collins" <XXXX@XXXXX.COM>schreef in bericht
news:1Nccb.3166$%XXXX@XXXXX.COM...

>Ron Tuijnman writes:
 >
 >
 >>I've searched the helpfiles extensively, but all I get is
 >>EXTRACT, no other DATE-functions.
 >>How can I retrieve the current DATE with SQL?
 >
 >It would help to know which database. In SQL-Server it's
GETDATE()

>IIRC.

....Just plain and simple Paradox SQL...
Look like you're out of luck :-/
You'll have to format the SQL in code first to insert the current
date, but that is not much code to write!
--
jc
Remove the -not from email