Converting text to dates

[ChrisP]

How to I convert a text field into a date eg I want to load data with
entries like "01 Jan 03" into a date field.

Thanks

[Aggro]

ChrisP wrote:

How to I convert a text field into a date eg I want to load data with
entries like "01 Jan 03" into a date field.

http://www.mysql.com/doc/en/Date_and...functions.html

[Aggro]

ChrisP wrote:

How to I convert a text field into a date eg I want to load data with
entries like "01 Jan 03" into a date field.

http://www.mysql.com/doc/en/Date_and...functions.html

[ChrisP]

Yes I've found those and str_to_date() looks ideal but I keep getting an
error message about an error in my sql syntax - I wonder what version
that function because available in because I am using 4.0.16 which is
the last version to have an odbc client available.

I've tried

select str_to_date ('1 Jan 2003','%e %b %Y');

as shown in the online manual and also

select str_to_date (my_field, '%e %b %Y') from table;

both with the same result
Aggro wrote:

http://www.mysql.com/doc/en/Date_and...functions.html

[ChrisP]

Yes I've found those and str_to_date() looks ideal but I keep getting an
error message about an error in my sql syntax - I wonder what version
that function because available in because I am using 4.0.16 which is
the last version to have an odbc client available.

I've tried

select str_to_date ('1 Jan 2003','%e %b %Y');

as shown in the online manual and also

select str_to_date (my_field, '%e %b %Y') from table;

both with the same result
Aggro wrote:

http://www.mysql.com/doc/en/Date_and...functions.html

[Aggro]

ChrisP wrote:

Yes I've found those and str_to_date() looks ideal but I keep getting an
error message about an error in my sql syntax - I wonder what version
that function because available in because I am using 4.0.16 which is
the last version to have an odbc client available.
"STR_TO_DATE() is available as of MySQL 4.1.1."

So you have too old version of mysql server. Either you need to install= 4.1.1 version or need to use other solution for this problem.

Perhaps you need to get the date as string and convert it into date in
your program.

[Aggro]

ChrisP wrote:

Yes I've found those and str_to_date() looks ideal but I keep getting an
error message about an error in my sql syntax - I wonder what version
that function because available in because I am using 4.0.16 which is
the last version to have an odbc client available.
"STR_TO_DATE() is available as of MySQL 4.1.1."

So you have too old version of mysql server. Either you need to install= 4.1.1 version or need to use other solution for this problem.

Perhaps you need to get the date as string and convert it into date in
your program.