Date processing with PostgreSQL

[MartinTeefy]

Hi,

I'd like to add PostgreSQL as a supported database for my helpdesk system. 95% of the SQL statements are generic via the keys being numeric in the main but I have some date related questions:

When i do an insert or update to a table what is the equivalent to MSSQL system variables Getdate() or MySQL's Curdate()

What is the best way to Select data using a datetime field or the equivalent of either SQL statements:

MySQL:

SELECT Count(*) FROM AON_APPOINTMENTS WHERE AP_USER_ID = gCurrentAppointee & " AND DATE_FORMAT(AP_START_DATETIME,%Y-%m-%d) = '" & Format(eachDay, "YYYY-MM-DD") & "'"

SQLite:

SELECT Count(*) FROM AON_APPOINTMENTS WHERE AP_USER_ID =
gCurrentAppointee & " AND DATE(AP_START_DATETIME) = '" & _
Format(eachDay, "YYYY-MM-DD") & "'"

Any advice is much appreciated
Martin

[Wild_Pointer]

Hello, Martin.

in postgresql current date can be obtained using CURRENT_DATE. For formating date field please use to_char function.

Good luck!