skip to main
|
skip to sidebar
Web Developers
PHP, MYSQL, HTML, JAVASCRIPT, CSS, JQUERY, TRIGGER
Mysql query to check day of week with timestamp
By Webdevelopmentlogics
It's the query to select the timestamps which is on Sunday
SELECT date_recorded FROM answers WHERE DAYOFWEEK( FROM_UNIXTIME( date_recorded, '%Y-%m-%d %h:%i:%s' ) ) = 1
1 Response to Mysql query to check day of week with timestamp
SergeySV
March 27, 2012 at 12:14 AM
SELECT date_recorded FROM answers WHERE DAYOFWEEK( FROM_UNIXTIME( date_recorded, '%Y-%m-%d' ) ) = 1
Something to say?
Older Post
< ||| > > >
Newer Post
Budget Honeymoon Packages
Home
Categories
Convert MYQL timestamp (1)
Djago rest framework (2)
Django (25)
Errors (1)
Javascript (2)
jQuery (2)
Magento 2 (5)
MYSQL (3)
PHP Mail problem in Windows server (1)
Python (12)
Regex (1)
Stoed procedure view and delete commands (1)
Blog Archive
►
2024
(1)
►
July
(1)
►
2023
(1)
►
January
(1)
►
2022
(5)
►
August
(1)
►
June
(1)
►
April
(1)
►
February
(2)
►
2021
(2)
►
August
(2)
►
2016
(6)
►
September
(1)
►
May
(1)
►
February
(4)
►
2015
(6)
►
December
(1)
►
April
(1)
►
March
(4)
►
2014
(8)
►
December
(1)
►
July
(2)
►
June
(1)
►
May
(1)
►
April
(3)
►
2013
(23)
►
November
(2)
►
October
(4)
►
June
(2)
►
April
(1)
►
March
(10)
►
February
(3)
►
January
(1)
►
2012
(8)
►
August
(1)
►
February
(2)
►
January
(5)
▼
2011
(5)
►
December
(1)
▼
May
(1)
Mysql query to check day of week with timestamp
►
January
(3)
►
2010
(3)
►
December
(1)
►
August
(1)
►
July
(1)
►
2009
(5)
►
August
(2)
►
July
(1)
►
June
(2)
►
2008
(16)
►
December
(2)
►
November
(1)
►
October
(2)
►
September
(1)
►
August
(1)
►
July
(3)
►
June
(6)
Feeds
Posts
Atom
Posts
Comments
Atom
Comments
ARCHIVES
2024
2023
2022
2021
2016
2015
2014
2013
2012
2011
2010
2009
2008
1 Response to Mysql query to check day of week with timestamp
SELECT date_recorded FROM answers WHERE DAYOFWEEK( FROM_UNIXTIME( date_recorded, '%Y-%m-%d' ) ) = 1
Something to say?