Maybe I misunderstood. You initially used AsDate (rather than AsDateTime) so
I assumed you didn't want the time part of the date, but in your other reply
you said:
>Time component was correct but not the date.
suggesting that you did. If you want time included then take the Trunc out.
ParamByName('DT').AsSQLTimeStamp :=
DateTimeToSQLTimeStamp(EffluentRec.DT);
Cheers,
Carl
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, February 26, 2007 10:23 AM
To: 'NZ Borland Developers Group - Delphi List'
Subject: RE: [DUG] Delphi SQL issue
I've had similar problems with Date and DateTime parameters so now I use
TimeStamp instead.
ParamByName('DT').AsSQLTimeStamp :=
DateTimeToSQLTimeStamp(Trunc(EffluentRec.DT));
should work.
Cheers,
Carl
_______________________________________________
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
