Date Formar

------=_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
Ezequiel Olmas [ Di, 16 August 2005 03:14 ] [ ID #924057 ]

Re: Date Formar

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 [at] 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 [at] m.gmane.org
Daniel Kasak [ Di, 16 August 2005 03:27 ] [ ID #924058 ]

Re: Date Formar

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 [at] m.gmane.org
Dennis Yu [ Di, 16 August 2005 03:36 ] [ ID #924059 ]
Datenbanken » gmane.comp.db.mysql.odbc » Date Formar

Vorheriges Thema: MyODBC install
Nächstes Thema: MYODBC