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

-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl