RE: Date/time format single query

Ref #1 & #2, just because they should do something doesn't mean they do.


I didn't know that CHAR() in SQL had an optional second parameter. That's perfect. Thank you.



-----Original Message-----
From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx]
Sent: Monday, October 28, 2019 4:43 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Date/time format single query

My first question, why can't you just return the timestamp?

Second question...dates and times in the DB don't have a format, why isn't the caller controlling the display?

If you really want to split and format them...
select char(date(current_timestamp), ISO) as theDate
, char(time(current_timestamp), USA) as theTime from sysibm.sysdummy1;


Charles



On Mon, Oct 28, 2019 at 3:09 PM Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

I have an external stored procedure that returns a result set to the
caller via an open cursor. I have a TIMESTAMP column that needs to be
returned as date & time separate, and the date & time need to be
formatted. I cannot globally change the date/time format. Short of
some SQL gymnastics, is there a good way to do this?

TIA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com