custom report by today's date

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

custom report by today's date

Postby tsuneoka » Wed Jan 14, 2009 6:08 pm

want to create a report showing today's date & yesterday's date stats.
how to create that filter
thanks
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: custom report by today's date

Postby kraada » Thu Jan 15, 2009 11:04 am

You'd need to create a stat that compares a hand's date with today's date and returns true if the hand happened today.

You'll need the PostgreSQL date/time functions, which you can read more about in this thread.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests