timestamps don't match my PC

[bball44]

The timestamps in the tables in my db (looking in PGAdmin) don't match my PC's clock. They are 4 hours later than the time on my PC. My computer is set to Eastern Daylight time. The times seem to be correct in PT3, but, for instance, the date_start field in the holdem_table_session_summary table has a time portion that is 4 hours ahead. I have been having problems setting up reports within PT3 that I woule like, and am instead querying directly within PGAdmin.

Is there a way I can make it so the timestamps in the tables themselves match the PC clock?

I'm not sure if this is the area to ask this question.

Thanks very much.

[WhiteRider]

Those date fields are in UTC - they are labelled as "timestamp without time zone"; in fact I think all dates in the database are stored like that as this makes them much more re-usable.
Postgres has date/time functions built in to convert to and from UTC.
http://www.postgresql.org/docs/8.3/static/functions-datetime.html

[bball44]

Thanks, this is a great help. Makes sense.

[spannerj]

Sorry to resurect an old post but I cant find the answer I want anywhere else.

I also have the problem of my session times not matching my PC.

I have only just signed up to PT3 and have never used PostgreSQL so could someone tell me (in simple terms) how I can fix this issue and set my timezone to GMT?

Thanks

[WhiteRider]

What site(s) are you playing at?
The hands are stored as UTC in the database but should be displayed in your local time in PT3.

[spannerj]

I'm playing on Absolute Poker.

How can I see what is stored in the database?

[WhiteRider]

Cereus (Absolute) write the timestamps of the hands incorrectly in the hand history files.
They write your local time but label it as ET so PT3 converts it.
Cereus are aware of this bug in their software and say they will fix it, but of course I don't know when that will be.
You may want to contact them and add your voice to the request to get it fixed.

[spannerj]

Ah I see. How annoying. Not the end of the world but a pain none the less.

I shall bounce them an email.

Thanks for your time.

[WhiteRider]

No problem - FWIW I have this issue too and have emailed them myself.

[jabbawok]

What site(s) are you playing at?
The hands are stored as UTC in the database but should be displayed in your local time in PT3.

I'm still trialling PT3 and would like some clarification with how it handles the timestamps. I've only been playing at PS and have the client set to AEST (my time zone). So the hand history shows it like this:

Code: Select all

2009/09/12 10:10:52 AEST [2009/09/11 20:10:52 ET]

But PT3 is displaying this:

Code: Select all

2009/09/12 20:10

Which is obviously not my local time. And I get the "date rollover" where in the evening the date is shown as the next day.

So how do I make PT3 show the correct AEST date/times?