now() gibt immer die Startzeit der aktuellen TX. Wenn Du innerhalb einer TX die exakte Zeit brauchst, gibt es was anderes.
AndreasCode:test=*# select now(); now ------------------------------- 2009-11-24 07:21:38.214483+01 (1 row) test=*# select timeofday(); timeofday ------------------------------------- Tue Nov 24 07:21:42.036023 2009 CET (1 row) test=*# select now(); now ------------------------------- 2009-11-24 07:21:38.214483+01 (1 row)
Geändert von Xandrian (24.11.2009 um 09:51 Uhr)
--
https://www.xing.com/profile/Andreas_Kretschmer7ads Das hatte dir akretschmer gestern schon gesagt und siehe da sobald du das machst, funktioniert es ;-)
nochmal wegen den micosekunden .. ob und wie (genauigkeit) die ueberhaupt gespeichert werden ist offenbar von einstellungen abhaengig ..
wenn du timeofday() (nach wie ak meint verwendest) scheinen die ohnehin nicht gespeichert zu werdenNote: When timestamp values are stored as double precision floating-point numbers (currently the default), the effective limit of precision may be less than 6. timestamp values are stored as seconds before or after midnight 2000-01-01. Microsecond precision is achieved for dates within a few years of 2000-01-01, but the precision degrades for dates further away. When timestamp values are stored as eight-byte integers (a compile-time option), microsecond precision is available over the full range of values. However eight-byte integer timestamps have a more limited range of dates than shown above: from 4713 BC up to 294276 AD. The same compile-time option also determines whether time and interval values are stored as floating-point or eight-byte integers. In the floating-point case, large interval values degrade in precision as the size of the interval increases.
also auf die präzission der microsekunden zu vertrauen scheint ne schlechte idee
det gleiche nur mit timeofday() auf meiner default installation ..
Code:select to_char(tstest, 'HHMISS.SS.MS.US') from tstest; "082046.46.004.004000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000" "082046.46.035.035000"
Geändert von symbiont (24.11.2009 um 10:09 Uhr)
Links: Tobias Bauer - IT- und Funkdienstleistungen - Bilderrahmen-kaufen.de - Der Onlineshop für Bilderrahmen & Fotorahmen - Funkforum
Lesezeichen