David Best
Member
How can I return an OCIDATETIME value from an external stored proc function?
OCIDATETIME
- Thread starter David Best
- Start date
By returning a TOCIDate type and using the OCIDateFromDateTime procedure to convert a Delphi Date/Time to an OCI Date/Time.
David Best
Member
I'm using Oracle 9.2.0.1 on W2K Server and find that the systimestamp function only has 1/100 second precision and I haven't found any setting that will increase it.
So I thought to use this as an experiment with writing extended stored procedures....bad choice it seems
The use is as the primary key of a chronological activity file, and it would alleviate needing a surrogate key. But no big deal.
So I thought to use this as an experiment with writing extended stored procedures....bad choice it seems
The use is as the primary key of a chronological activity file, and it would alleviate needing a surrogate key. But no big deal.
I see. That is indeed a problem. You can only circumvent this by converting the timestamp to/from a character string representation with full precision.
Similar threads
- Discussion
