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
by 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
by 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]
Users browsing this forum: No registered users and 2 guests