RE: FN-FORUM mysql date query

date posted 20th June 2002 16:52

select date_format(curdate(),'%D-%M-%Y');

gives 20th-June-2002 on my system

Check the manual for other date format modifiers available.
HTH
Rich

-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Rob Garbutt
Sent: 20 June 2002 16:12
To: [EMAIL REMOVED]
Subject: FN-FORUM mysql date query


Hi all,

I'm a field using the 'Date' type in a mysql database field. Is it possible
to select a format for the date or can you only use the default date of
2002-06-06.

tia!

Robin Garbutt
Portfolio Art & Design Ltd
Tel - +44 (0) 1204 383822
Fax - +44 (0) 1204 383866
Mob - +44 (0) 7811 185490
e-mail - [EMAIL REMOVED]

For further information please visit us at :-
www.portfoliodesign.net

The contents of this e-mail are confidential to the ordinary user of the
e-mail address to which it was addressed and may also be privileged. If you
are not the addressee of this e-mail you may not copy, forward, disclose or
otherwise use it or any part of it in any form whatsoever. If you have
received this e-mail in error please e-mail the sender.



================================================================
= ************************* SilkPHP ************************** =
= ---------> Free PHP Scripts for your web sites