Re: Workings of Forum software
From: Lew Pitcher <lew.pitcher_at_digitalfreehold.ca>
Date: Mon, 22 Oct 2018 19:00:23 -0400
Message-ID: <pqlkq7$765$1_at_dont-email.me>
>>>
>>>
>
> USDate format is mm/dd/yy ('%m/%d/%Y'). The rest of the world uses a
> logical format such as you showed.
Date: Mon, 22 Oct 2018 19:00:23 -0400
Message-ID: <pqlkq7$765$1_at_dont-email.me>
Jerry Stuckle wrote:
> Lew,
>
> Please see below...
>
> On 10/22/2018 2:22 PM, Lew Pitcher wrote:
> <snip>
>>> For example: >>> mysql> select now() as Now, date(now()) as ISODate, >>> date_format(now(),'%d/%m/%Y') as USDate, time(now()) as >>> ISOTime, date_format(now(),'%h:%s %p') as USTime; >> >> Oops... made a mistake in that format, it should be '%h:%i %p' >> >>> +---------------------+------------+------------+----------+----------+ >>> | Now | ISODate | USDate | ISOTime | USTime>>> | |
>>>
+---------------------+------------+------------+----------+----------+ >>> | 2018-10-22 14:20:08 | 2018-10-22 | 22/10/2018 | 14:20:08 | 02:08 PM>>> | |
>>>
+---------------------+------------+------------+----------+----------+ >>> 1 row in set (0.00 sec) >>> >>> HTH >> >> mysql> select now() as Now, date(now()) as ISODate, >> date_format(now(),'%d/%m/%Y') as USDate, time(now()) as ISOTime, >> date_format(now(),'%h:%i %p') as USTime; >> +---------------------+------------+------------+----------+----------+ >> | Now | ISODate | USDate | ISOTime | USTime | >> +---------------------+------------+------------+----------+----------+ >> | 2018-10-22 14:21:50 | 2018-10-22 | 22/10/2018 | 14:21:50 | 02:21 PM | >> +---------------------+------------+------------+----------+----------+ >> 1 row in set (0.00 sec) >> >> >> >>
>
> USDate format is mm/dd/yy ('%m/%d/%Y'). The rest of the world uses a
> logical format such as you showed.
My apologies in misnaming the format.
-- Lew Pitcher "In Skills, We Trust"Received on Tue Oct 23 2018 - 01:00:23 CEST