I have a postgres database on Heroku that is set to be on UTC. When I query with TablePlus, I see the timestamps returned in UTC as expected. When I run the same query with dbForget Studio 2019 for PostgreSQL v2.2.207, I get expected results.
Example:
TablePlus: 2020-01-06 21:21:26.454707
dbForge: 2020-01-06 09:21:26.454707
It's clearly the same data, sorta, but dbForge looks to be doing something odd (showing AM/PM but not including that info?).
TImestamps not in expected timezone
Re: TImestamps not in expected timezone
You could try changing this in the 'Data Editor -> Formatting' section of the 'Options' window (select 'Tools -> Options...' from the main menu) having selected 'Timestamp' in the 'Data type' drop-down menu.
Re: TImestamps not in expected timezone
Thank you, alexa.
What would I change it .. to? It appears to already be in the format desired, but it's not including the AM/PM information. I actually don't WANT the AM/PM but want the results in 24-hour time.
I did discover a post where someone suggested adding tt to the end to get the AM/PM. That ... does seem to clarify the results, but as I said before it's still not what I would consider right or comparable to other datetime formats. It should already be showing results in 24-hour time when the tt paramete is missing. Is this is a bug?
What format should I use to get the timestamp in a standard, expected format like ISO 8601--or at least what TablePlus is using?
What would I change it .. to? It appears to already be in the format desired, but it's not including the AM/PM information. I actually don't WANT the AM/PM but want the results in 24-hour time.
I did discover a post where someone suggested adding tt to the end to get the AM/PM. That ... does seem to clarify the results, but as I said before it's still not what I would consider right or comparable to other datetime formats. It should already be showing results in 24-hour time when the tt paramete is missing. Is this is a bug?
What format should I use to get the timestamp in a standard, expected format like ISO 8601--or at least what TablePlus is using?
Re: TImestamps not in expected timezone
Please perform the following:
1. Select 'Tools -> Options...' from the main menu.
2. Navigate to the 'Data Editor -> Formatting' section.
3. Select 'Timestamp' in the 'Data type' drop-down menu.
4. Replace hh with HH in the 'Edit format' field.
1. Select 'Tools -> Options...' from the main menu.
2. Navigate to the 'Data Editor -> Formatting' section.
3. Select 'Timestamp' in the 'Data type' drop-down menu.
4. Replace hh with HH in the 'Edit format' field.
Re: TImestamps not in expected timezone
Thank you for bringing this to our attention.
We will fix it in one of the next product versions.
We will fix it in one of the next product versions.