1.
SELECT
unix_timestamp( curdate( ) )
AS
TODAY, unix_timestamp( DATE_SUB( curdate( ) , INTERVAL 1
YEAR
) )
AS
LASTYEAR, unix_timestamp(
"2005-10-01"
)
AS
THISQUARTER, unix_timestamp(DATE_SUB(
"2005-10-01"
, INTERVAL 1
YEAR
) )
AS
LASTQUARTER
2.
3.
SELECT
(unix_timestamp(
"2005-11-15"
) - unix_timestamp(
"2005-10-01"
)) / 86400
4.
5.
SELECT
*
FROM
mail_stats
WHERE
DATE_SUB(DATE_FORMAT( complete_date,
"%Y-%m-%d"
),INTERVAL 1
DAY
) =
"2005-11-09"
No comments:
Post a Comment