Date/Time function

[Aliq2014]

Hello All,

I'm looking for date and time from the below formula:

SELECT (dateadd(hour,datediff(hour,getutcdate(),getdate()),dateadd(s,JNL.DATE_DAY,convert(datetime,'1990-01-01 00:00:00',102)))) as Date
From JNL

I get the following error "Argument data type date is invalid for argument 2 of dateadd function". Would someone please advise? I'm new to programming.

Thanks,

Ali

 

[Aliq2014]

My ultimate goal is to retrieve the date and time from the Date_Day field from a sql database

 

[mole999]

Select
Date_Day
From
JNL

formatting would be the next step

convert(varchar(11),Date_Day,103) As [Date]
produces a English Date that's just one way, depends on what is stored n the file

 

[Aliq2014]

Thank you Mole999, that field has a time as well is there a way I can pull the date and time (e.x. 2015-10-31 00:00:00)

 

[mole999]

if you have a read over this > Date Functions in SQL Server and MySQL

I think you were try > SQL Server DATEPART() Function

you'll be heading toward

DATEPART(yyyy,Date_Day)+ '-' +DATEPART(mm,Date_Day)+ '-' +DATEPART(dd,Date_Day)+ ' ' +DATEPART(hh,Date_Day)+ ':' +DATEPART(mi,Date_Day)+ ':' +DATEPART(ss,Date_Day)

 

[Aliq2014]

Thank you. I'm using PowerPivot query design and received an error. "datepart is not supported by date function datepart for data type date (Microsoft SQL Server error:9810)

 

[mole999]

I know nothing about powerpivot