suppose you use timestamp, but you need to get the date
DISTINCT DATE( `LoginDate` )
FROM
loginlog
DISTINCT left( `LoginDate` , 10 ) AS LDate
FROM
loginlog
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
相关推荐
HDR Deghosting: How to deal with Saturation, http://www.cs.duke.edu/~junhu/CVPR2013/
摸底考试作文垃圾处理how to deal with garbagePPT课件.pptx
摸底考试作文垃圾处理how to deal with garbagePPT学习教案.pptx
How To Do Everything With PHP & MySQL.pdf
how to work with crystal report in sap business one
How to connect with VB to Mysql database
《统计陷阱》本书是美国著名的统计学家达菜尔·哈夫的名著。该书自1954年出版至今,多次重印并被译成多国文字,是一本影响深远的经典性著作。《统计陷阱》一书之所以能够历久弥新,是因为其实用性。...
Python零基础10天进阶班【13课程:SQL数据分析及变更(上)】
统计陷阱的英文版,本人很推荐 《统计陷阱》是美国统计学家达莱尔·哈夫的名著,自1954年出版至今,多次重印,被译为多种文字,影响深远。 在日常的经济生活中,我们将接触到越来越多的统计数据和资料,例如...
How to come up with new ideas 一位计算机图形学和图像处理领域的牛人做的关于寻找新想法的报告
How to deal with issues like dangling revisions and disjointed branches How to pinpoint who made specific changes How to deal with textual and binary conflicts How to work with hosted solutions like ...
an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before summarizing additional resources that will enable you to optimize MySQL Cluster performance with your ...
1.Thinking With Data How To Turn Information Into Insights 2014; 2.英文原版,PDF格式;
How to Learn Any Language 全英!!!
How do we deal with our problemsPPT教案.pptx
how to draw with AI,教你如何用AI画人物,轻松易学
这是一本C++的初级教课书,第10版,作者是Paul Deitel and Harvey Deitel
How to Do Everything with JavaScript by Scott Duffy - Mcgraw-Hill 2003
NULL 博文链接:https://lwg2001s.iteye.com/blog/1600931
How to Tango with Django 1.7 这本书的pdf版本。 在线版本: http://www.tangowithdjango.com/book17/