Getting Current Date is SQL

[ponyryd]

I'm a Progress newbie, can anyone tell me how to get the current date as part of a select statement. Similiar to MS SQL "SELECT GETDATE()" function.

Thanks in advance for your help!
PonyRyd

 

[cywong119]

solution: CURDATE()

The similar function of GetDate() in Progress is: CURDATE()

Example:

INSERT INTO objects (object_owner, object_id, create_date)
VALUES (USER, 1001, CURDATE()) ;

Good luck!

P.S. You can find all progress database functions in Electronic Documentation.