Posted by samuelhon on 12/04/06 14:21

Hi

to_date is for Oracle

Pull out the date and do the conversion in php. Let the database do
data things

Sam

On Dec 4, 2:02 pm, "Sonnich" <sonnich.jen...@elektrobit.com> wrote:
> I read this and got confused...
>
> I use PHP and got this:
> $sql = "delete from blabla where startdate< =
> to_date('2000.05.05','YYYY-MM-DD')";
> $result=odbc_exec($conn, $sql);
>
> Result: Warning: odbc_exec() [function.odbc-exec]: SQL error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]'to_date' is not a
> recognized function name.
>
> to_date should work?
>
> At the other end i'd like to read out startdate as a date var or format
> it as I need.... (dd.mm.yyyy). Convert makes me confused... help
> please?
>
> S

[Back to original message]