--ibTvN161/egqYuK8
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Fri, May 09, 2008 at 04:59:30AM -0400, Justin wrote:
> generail this don't hurt us but we have some needs with data coming
from=
=20
> manufacturing testing applications that needs to keep the timestamps to=
=20
> .000,000,001 aka 1 nano second.=20
> what would be the easiest way to do this?=20
I would suggest storing it as epoch time (seconds since X) in a numeric
fields and create some helper functions to get data in and out in the
right format. Or a timestamp(0) column with an additional nano-second
column.
Depending on how often you use it it may be interesting to create a
specific type, but this may come close enough.
Have a nice day,
--=20
Martijn van Oosterhout <kleptog@[EMAIL PROTECTED]
> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while=20
> boarding. Thank you for flying nlogn airlines.
--ibTvN161/egqYuK8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFIJBZdIB7bNG8LQkwRAn2AAJ4pW4Jckd6HbxthA5WpDBrfgDeXpQCfZWE4
TySjilSM9NK//1YWu5VSJQs=
=OO0i
-----END PGP SIGNATURE-----
--ibTvN161/egqYuK8--
|
