Re: Date/time format single query

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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