Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Current Date

Status
Not open for further replies.
rwaldron

rwaldron

MIS
Aug 6, 2002
53
IE
Hiya all,
Quick Silly Question..

Does anyone know how to return the current date in Pervasive 7?

SQL uses GETDATE()..
I have also tried SYSDATE

I am trying to do a search for records from the last 3 Months so I am looking for syntax similar to the SQL Version.
ie: GETDATE() - 90

Thx,
Ray.
 
Sort by date Sort by votes
Try these ones:

CURDATE, CURTIME, NOW

CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP

*Potential Problem* - I'm getting this from a P.SQL8 manual.

Hope it helps....

Tom
 
Upvote 0 Downvote
CURDATE should work for PSQL 7, 8, and 9.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wyngat
  • Locked
  • Question
Dates in btrieve
Replies
2
Views
91
wyngat
wyngat
cogebi
  • Locked
  • Question
We currently use Macola 7.5 software (networked) which utilizes Btriev 1
Replies
2
Views
115
vanpat
vanpat

Part and Inventory Search

Sponsor

Back
Top