TSQL - Conversion of Epcoh to Datetime

Convert Current UTC date to Epoch


SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
SELECT DATEDIFF(s, '19700101', GETUTCDATE())


Convert Epoch to dateTime

select dateadd(ss, epoch, '19700101')

SELECT DATEADD(s, epoch, '1970-01-01 00:00:00')


Example
select dateadd(ss, 1394796484, '19700101')

SELECT DATEADD(s, 1393345800, '1970-01-01 00:00:00')

Comments

Post a Comment

Popular posts from this blog

SQL Server MDS : How to Know Actual MDS Table name for Model Entity and Column name for the Attribute

How to Know Actual MDS Table name for Model Entity and Column name for the Attribute . here is the Script  USE MDS ------------------------------------------------------------ -- TODO: Define Model name, Entity name, and Attribute Name        DECLARE @Model NVARCHAR ( 50 )        = '<<GiveModelName>>' ;        DECLARE @Entity_Name NVARCHAR ( 50 ) = '<<GiveEntityName>>' ;        DECLARE @Attribute_Name NVARCHAR ( 50 )= '<<GiveAttributeName>>' ; ------------------------------------------------------------ -- Set @Table name        DECLARE @Table NVARCHAR ( 128 );              SELECT @Table = EntityTable FROM mdm . viw_SYSTEM_SCHEMA_ENTITY WHERE Model_Name = @Model AND name = @Entity_Name ; --...
Read more

SSRS : [Teradata Database] 3939 There is a mismatch between the number of parameters specified and the number of parameters required.

Error : [Teradata Database] 3939   There is a mismatch between the number of parameters specified and the number of parameters required. When we get this Error : when we are creating SSRS reports on Teradata database and in which when we are using parameters in the dataset in wrong style\format. Just for Info :  to connect Terdata we need to have  .Net Data provider for Terdata  when we installed this on our machine  Then we are able to see Teradata data source type in SSRS. How to Solve this issue :  This error will come if we are not using correct syntax to create parameterized data set .  The correct way is we need to ?  for parameter The report parameters can be named or unnamed. Teradata only supports unnamed parameters. An unnamed parameter is denoted by a ‘?’, and is merely a placeholder for data that is going to be entered at report processing time. For example, the following is a dataset with a single-value ...
Read more

SSAS Error : XML parsing failed at line 1, column 0: A document must contain exactly one root element

when i am planning to redeploy the Cube . I took the latest cube from Production and want to deploy in Dev server . i am getting the fallowing error . Error 33 XML parsing failed at line 1, column 0: A document must contain exactly one root element. .  0 0 Error 34 Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\E:\MSSQL\Data\DbR4.194.db\MSC ID.112677.dim.xml'.  0 0 Solution : Go the path specified the in the Error on the deploying server not on you local server . and there you will find that file with 0 KB  . Delete that file and redeploy the project .
Read more