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