Date Formar

Date Formar

am 16.08.2005 03:14:16 von Ezequiel Olmas

------=_NextPart_000_0044_01C5A2AF.FEF19970
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

MySql not support another date format that yyyy/mm/dd ? I want to pass =
a bind variable with format dd/mm/yyyy and mysql return error for the =
format.
Thanks

------=_NextPart_000_0044_01C5A2AF.FEF19970--






___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar

Re: Date Formar

am 16.08.2005 03:27:18 von Daniel Kasak

Ezequiel Olmas wrote:

>MySql not support another date format that yyyy/mm/dd ? I want to pass a bind variable with format dd/mm/yyyy and mysql return error for the format.
>Thanks
>
>
No. That's the standard format for dates. You should reformat it from
your client application before sending it to MySQL.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Date Formar

am 16.08.2005 03:36:32 von Dennis Yu

May be you'd like to study the function DATE_FORMAT(date,format) in
MySQL manual chapter 12.

Ezequiel Olmas wrote:
> MySql not support another date format that yyyy/mm/dd ? I want to pass a bind variable with format dd/mm/yyyy and mysql return error for the format.
> Thanks
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org