This may have been brought up before but I couldn’t find anything. I am pulling date/time from a SQL Server database using the classic asp server model. I then apply time formatting so it will read like 10:46:09 AM. I thought everything was fine until a client emails me and said all of their timestamps were displaying an hour off. Now, our server that this data comes from is in eastern time, and they are viewing it on a browser in Central time zone, but still, shouldn’t it pull the actual data from the database? I know about time zone when using the datepicker or inserting data, but I’m just displaying data from a Query. Also, when I take the formatting off, it looks like it is in UTC. I don’t mind the UTC format, but the time zone is off.
Example:
Pulling from plain classic ASP or PHP page:
10:46:09 AM formatting applied
2018-10-15 10:46:09.000 unformatted
From Wappler:
09:46:09 AM with formatting
2018-10-15T14:46:09Z unformatted
This is the formatting I’m applying:
{{TotalDoorTimeStart.formatDate(“hh:mm ss a”)}}
Is this normal? If so, how do I localize the formatting? I thought the date/time data would be exactly what is coming from the database.
Last updated: