how to deal with MYSQL DATE

suppose you use timestamp, but you need to get the date

 

SELECT

DISTINCT DATE( `LoginDate` )
FROM

loginlog

 

SELECT

DISTINCT left( `LoginDate` , 10 ) AS LDate

FROM

loginlog

 

SELECT

DISTINCT date_format( `LoginDate` , '%Y-%m-%d' ) AS 'Ldate'
FROM

loginlog

 

Suppose you use intval time format

SELECT

  DISTINCT FROM_UNIXTIME( LoginDate, '%Y%-m%-d%' ) AS 'Ldate'
FROM

loginlog