Database time

Scriptcase 9 General
#1

I have an automated procedure that adds records to my database. This process uses the UTC time/database server time.
The issue is that I also have a form in my application that creates entries in this same table but it uses the user’s computer time for the entry. What is the best method to make sure these times use the same timezone?

My thought is to have everything use the UTC time and then have the user profile include a timezone entry and adjust how the time is displayed. The only issue I have is how can I ensure my forms are inserting record using the UTC time and not the local time zone.

Regards,

Keith

#2

You can create a function for get datetime of your database.
Use that function for yours procedures and forms.

#3

Try not to set it in database directly. Use SC procedures.