Mahadevan Business Intelligence
Labels
ASP.NET
(1)
Data Model
(1)
Django
(1)
MDX
(15)
Python
(3)
Redshift
(3)
SSAS
(15)
SSRS
(3)
T-SQL
(29)
Monday, 25 November 2013
Convert Unix Timestamp to Date Format
SELECT DATE_FORMAT(FROM_UNIXTIME(TimeStamp), '%d-%m-%Y %h:%i:%s') AS LogDate
FROM dbo.reportlog
ORDER BY Timestamp DESC
LIMIT 10
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
