Re: Formatting a DATE differently using SQL

[Robert Clay <zreclay@xxxxxxxxx>]

I tried making the changes *YMD and *PERIOD (just to test) in the JDBC 
settings in Run SQL Scripts... and the session re-connected 
successfully.  But, when I ran the statement, I still got MM/DD/YY 
format with LOCAL :

SELECT CHAR(StartDate, LOCAL), CHAR(EndDate, LOCAL) FROM (SELECT 
MIN(dayid) as StartDate, MAX(dayid) AS EndDate FROM mySchema.ludate 
WHERE yearid = '2014' AND datemn = '01' ) A

Do I need to change the 2nd attribute as well?


"Contrariwise, if it was so, it might be; and if it were so, it would 
be; but as it isn't, it ain't. That's logic."--Tweedledee
On 09/05/2013 1:46 PM, Jack Callahan wrote:
>   For embedded SQL: the SET OPTION statement provides you with a way to
> override the default date formatting ( along with other compile time and
> execution time settings)
> You would execute this statement prior to any other SQL statement to set
> the environment:
>
> SET OPTION DATFMT=*YMD, DATSEP=*SLASH
>
> On the interactive side:
> For STRSQL:  F13>1 change session attributes
> For Run SQL Statements:  Connection>JDBC Settings
>
>
> Jack

s/b
SET OPTION DATFMT=*MDY, DATSEP=*SLASH

not

SET OPTION DATFMT=*YMD, DATSEP=*SLASH

Jack