[SOLVED] Time Format

[pjtuloup]

Hi,

I need to save the time in a field of a database table, this field being in TIME format.
But DataModule1.SQLQuery1.ParamByName('Chp4t').AsTime := Time; leaves the time in hh:mm:ss.xxxx format which is obviously refused by the database... How to reformat the time in hh:mm:ss?

It's crazy but I haven't found anything usable (or understandable by me) on this problem

[paweld]

If the RDBMS will accept time as string, you can try:

Code: Pascal  [Select][+][-]

1. DataModule1.SQLQuery1.ParamByName('Chp4t').AsString := FormatDateTime('hh:nn:ss', Time);

[pjtuloup]

Thanks Paweld !

But it's a little bit strange to have to use this (I think)

[paweld]

I also find it strange. If the column is defined as "TIME" (in a db table), then passing the parameter as time should work without any problem.

[CharlyTango]

But DataModule1.SQLQuery1.ParamByName('Chp4t').AsTime := Time; leaves the time in hh:mm:ss.xxxx format which is obviously refused by the database

if I don't need the clients time (lets see for starting and stopping something) but I need the DateTime or Timestamp for (e.g logging purposes - Time_created or Time_Updated) i leave the job to the SQL-Server.
You can create the table in a manner that creation dates were inserted as well as update datetimes. Sometimes special triggers will do the job.

In these cases, there are no more problems with date fields