About Uemerson

Uemerson · ‎08-29-2018

Hi ChrisNZ, 1. The field "DATE" is a number expressing a date (Ex.: 20180829). 2. My query was running in Oracle SQL, now I need to migrate the code to SAS DataFlux. Solution: I tried the code below, and It works well. I think that the problem was the format used with PUT function. select count(0) AS Ten_Days_Before from [TABLE] where PUT(DATE,8.) = PUT(current_date-10,yymmddn8.) ; Thanks for your reply!

Uemerson · ‎08-28-2018

Hello ChrisNZ, Thanks for your reply. The different types I mean are about the field called "DATE" and the system variable "current_date". The first one is Numeric, and after use the function PUT it will be transformed into Double, right? And the second one is a date, and I don´t know what type it will be after PUT function, anyway, the result of this example I gave is 0. Do you have another function or logic to do this count comparing these fields? Thank you!

Uemerson · ‎08-22-2018

Hello experts! I am trying to convert the code below (Oracle SQL) to FedSQL used by SAS DataFlux. The field called in this example "DATE" is a numeric type with the format 'yyyymmdd'. Name Type DATE NUMBER(8) select count(0) AS Ten_Days_Before from [TABLE] where DATE = TO_CHAR(SYSDATE-10, 'yyyymmdd'); Any suggestion? I tried the function "PUT" with the code below, but It´s not working because of different data types. select count(0) AS Ten_Days_Before from [TABLE] where PUT(DATE,yymmddn8.) = PUT(current_date-10,yymmddn8.) ; Thank you!

Online Status	Offline
Date Last Visited	‎08-29-2018 05:50 AM

Re: FedSQL Convert and Compare current_date

Re: FedSQL Convert and Compare current_date

FedSQL Convert and Compare current_date

Re: FedSQL Convert and Compare current_date

Re: FedSQL Convert and Compare current_date

FedSQL Convert and Compare current_date