[Monetdb-developers] Extending TimeStamp and Time to support 24+ hour days
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
In some fields the usage of 32 or 36 hours in a day are common. The extra time after midnight is used to indicate that a certain operation is linear in time. My particular use case is public transport.
Is there any other way that using TIMESTAMP to get the 'features' of TIME, but than in a 32h or 36h day?
Stefan
Stefan
This seems a weir solution, ie overspecifying a data type. There must be better ways to implement this using the normal specs of data types. Probably a combination of time and duration my solve your problem/application.
Anyway we are not going to adapt types just to allow hacks..
Niels
On Thu, Dec 15, 2011 at 03:55:55AM +0100, Stefan de Konink wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
In some fields the usage of 32 or 36 hours in a day are common. The extra time after midnight is used to indicate that a certain operation is linear in time. My particular use case is public transport.
Is there any other way that using TIMESTAMP to get the 'features' of TIME, but than in a 32h or 36h day?
Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEAREKAAYFAk7pYboACgkQYH1+F2Rqwn3CQgCfU0CCgnJgxJj0lFW9RC+qiyz+ Pj0An1Vn8oZETQTCCeIFv+LgWOAx7ERQ =wSgl -----END PGP SIGNATURE-----
10 Tips for Better Server Consolidation Server virtualization is being driven by many needs. But none more important than the need to reduce IT complexity while improving strategic productivity. Learn More! http://www.accelacomm.com/jaw/sdnl/114/51507609/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Niels Nes -
Stefan de Konink