|
|
Posted by Captain Paralytic on 08/02/07 10:00
On 2 Aug, 10:41, Chris Tate-Davies <christatedav...@gmail.com> wrote:
> Hello. I have a generic table used for many different generic
> functions. the fields are mainly varchar's but one of these varchars
> contains dates (in the format dd/mm/yyyy) for one reason or another.
>
> My question is, can I perform a query on this table, using date
> functions on this varchar field? I.e. search for the latest date?
>
> Thanks, Chris
You can by using the STR_TO_DATE function, but it won't be very
efficient.
Navigation:
[Reply to this message]
|