Date: Mon, 24 Mar 2003 15:58:21 +0200
Reply-To: Arto Raiskio <arto@RAISKIO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arto Raiskio <arto@RAISKIO.COM>
Subject: Re: equivalent to Dateadd(seconds,var,'1 Jan 1970')
"Arun Kumar" wrote
> You can use INTNX function for this. Like INTNX ('Seconds' , S, K), Where
> 'K' is the increment by which you want your date variable 'S' to be
right inside the Proc Sql statement? how?
currently the SQL Server View and Stored procedure looks like
SELECT from dbo.mytable.item1, dateadd('seconds',myvarinseconds,'01 Jan
WHERE (dateadd('seconds',myvarinseconds,'01 Jan 1970') > '03/20/2003
or did you mean do a generic extract and then apply intnx?
I wanted to do it all in one proc sql step without a data step at the end.
> have some data in SQL server and created views and stored procedures
> directly in SQL server to see the formats and variables
> now, what might be the equivalent in Proc Sql to the dateadd() function?
> k = number of seconds past since 01/01/1970 00:00:00 hour
> select DateAdd("s", k, "01.01.1970") formats the data into the format of
> 03/24/2003 00:00:00