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>


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

Original text of this message