session start time customized (2 hours earlier) .WHERE SAVE?

[marvin]

1) i wish create 1 stat that define start time of session 2 hours before than appear on history hands. how can i do? where i can customize it for found it when i want configure the report STATISTIC CASH-SUMMARY-GROUPED BY SESSION?

[kraada]

Can you explain a bit about what you are trying to accomplish by doing this? If you are having problems with sessions running over midnight and getting split over two different days you can change your "My Day Starts At" value in the Configure -> Reporting Options area and that will solve your problem without custom stats.

[marvin]

my problem is that i dont know why, but PT4 shows "04:00 pm" if the session starts on 02:00 pm (may be why poker room is on another time zone?) so i wish correct it with another stat that use that variable - 2 hours. how is the syntax for doing that? i wish correct also the format, using 24 hr (i wish have 16:00 instead 4:00 pm)

[kraada]

We do not have localization setups to show 24 hour clocks. What site are you playing at?

[marvin]

i think is a PT4 bug.
the site is Netbet.it (Ipoker network for italian players). now (at 8:38 am) i have tried to play 5-6 hands. italian hour is 8:38 am, and the HH loaded on my hard disk shows correctly 8:38:

M2FC3300656450CL</tablename> <tablecurrency>EUR</tablecurrency> <duration>00:04</duration> <gamecount>12</gamecount> <startdate>09/10/2012 08:38</startdate>
PT4 hand history viewer shows 8:38, BUT REPORT (cash, Play Poker, View Today Hands, My Hands, Time) SHOW start time = 10:38!!

[WhiteRider]

The problem is that iPoker do not specify the time zone in their hand histories, so PT4 does not know how to adjust it. We plan to add an option to configure time adjustments on a per-site basis – if you want to get a notification when this functionality is added please open a Support Ticket.

[marvin]

cant i create a customized stat? if i can how would be it? (start session customized = start-120 min)

[WhiteRider]

You could create a custom stat, but you'd need a few for different report types, and it wouldn't affect things like filters and day groupings, so I'm not sure how practical it would be.

If you want to try this, duplicate the stat you're interested in, and the column it uses, and add something like this to the time expression in the column:

- interval '2 hours'

[marvin]

i have created new stat, "session start - 2", duplicating "session start" and its column (session_date_start).
i have generated session_date_start_minus2 (a new column, with this expression:
datefix_fromutc_noadjust[ cash_table_session_summary.date_start - interval '2 hours']

Then, my new stat is: "session start - 2" with this expression: "session_date_start_minus2"
in the report it shows "Invalid Date: 15" (instead session start shows "20/10/09 1:02 am")

[kraada]

Try it like this instead:

datefix_fromutc_noadjust[ cash_table_session_summary.date_start ] - interval '2 hours'