×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
