Tagged Questions
1
vote
2answers
79 views
SQL date conversion for 8 char value with 00 as days
I have been having trouble trying to figure out how to properly convert the data. In its current form it is varchar and the data is as follows:
19260200,
19770900,
20030400,
20120300,
20020500,
So ...
0
votes
3answers
460 views
Get Day, Month, Year, Lifetime total records with one query w/ optimizations
I have a Postgres DB running 7.4 (Yeah we're in the midst of upgrading)
I have four separate queries to get the Daily, Monthly, Yearly and Lifetime record counts
SELECT COUNT(field)
FROM database
...
