I'd like to add DB2 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:
SELECT Count(*) FROM AON_APPOINTMENTS WHERE AP_USER_ID = gCurrentAppointee & " AND DATE_FORMAT(AP_START_DATETIME,%Y-%m-%d) = '" & Format(eachDay, "YYYY-MM-DD") & "'"
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
Forum related to DB2
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest