Re: Workings of Forum software
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Mon, 22 Oct 2018 17:45:24 -0400
Message-ID: <pqlgdk$gvg$1_at_jstuckle.eternal-september.org>
>
> Oops... made a mistake in that format, it should be '%h:%i %p'
>
>
> 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)
>
>
>
>
Date: Mon, 22 Oct 2018 17:45:24 -0400
Message-ID: <pqlgdk$gvg$1_at_jstuckle.eternal-september.org>
Lew,
[Quoted] 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)
>
>
>
>
[Quoted] USDate format is mm/dd/yy ('%m/%d/%Y'). The rest of the world uses a logical format such as you showed.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Mon Oct 22 2018 - 23:45:24 CEST