Passing datetime with milliseconds to stored proc

Bob Murdoch

Delphi Developer

Sat, 09 Apr 2005 22:52:45 GMT

Passing datetime with milliseconds to stored proc

I have a dialect1 database with a stored proc that has a date type input
parameter.

In Delphi, I'm assigning that parameter like this:

paramByName('log_timestamp').asDateTime := now;

However, the milliseconds are not being stored in the db. I have
verified this by doing a 'select cast(log_timestamp) as char(50))', and
it always shows .000 as the milliseconds.

So the question is, how can I pass a dateTime thru a stored proc so that
the milliseconds are stored?

tia,

Bob M..

Bob Murdoc

Delphi Developer

Sat, 09 Apr 2005 23:19:55 GMT

Re:Passing datetime with milliseconds to stored proc

Quote

"Craig Stuntz [TeamB]" wrote:
> IB's handling of milliseconds is marginal at best. The DB file
> itself can store them, but the IB date APIs are based on a C TM struct
> which simply has no place for ms. So you can either write UDFs which
> read/write the raw field data or you can just use a NUMERIC column to
> store the milliseconds as an integer.

Thanks Craig. That explains it.

I'm going to modify the routine to add a sequence number to each row
based on GetTickCount. That should allow me to pull them out in order.

Bob M..

Other Threads

1. Milliseconds removed from a DATETIME parameter to a SQL7 stored procedure

2. *** Using dataset returnet by a stored proc inside another stored proc ***

3. Passing a stored procedure two datetime parameters?

4. Passing DateTime parameters to a stored procedure on the server

5. Please help -- Stored Proc parameter passing.

6. Passing SQL 7 GUID fields to stored proc and tables in Delphi

7. how to pass a list or long string from Oracle stored proc to TStoredProc in Borland

8. Passing NULLs in a DBXpress Stored Proc

9. *** Milliseconds error in datetime fields ***

10. DATETIME parameters have milliseconds removed.