SQL Statement for DateTime Field

Hi all together,

i have a table with a DateTime field. Is it possible to write this
field via SQL Statement. Each time i try it i get an Type mismatch!

UPDATE "User" SET Lastlogin=335.584 WHERE Name='LoginName'

If i try other fields in the "Loginname" rows everything works fine.

i would be glad if someone would throw me some lines.

Regard from the lake constance, germany!

Carsten

Please try following query:

UPDATE "User" SET Lastlogin=TIMESTAMP '2009-02-03 04:05:06' WHERE
Name='LoginName'

Regards,
Alex

Carsten Groh wrote:
> Hi all together,
>
> i have a table with a DateTime field. Is it possible to write this
> field via SQL Statement. Each time i try it i get an Type mismatch!
>
> UPDATE "User" SET Lastlogin=335.584 WHERE Name='LoginName'
>
> If i try other fields in the "Loginname" rows everything works fine.
>
> i would be glad if someone would throw me some lines.
>
> Regard from the lake constance, germany!
>
> Carsten

Hi Alex,

> UPDATE "User" SET Lastlogin=TIMESTAMP '2009-02-03 04:05:06' WHERE
> Name='LoginName'

Works perfect - as always after your hints! Thanks a lot!

Regard from the lake constance, Germany!

Carsten