[Monetdb-developers] Extending TimeStamp and Time to support 24+ hour days

Niels Nes Niels.Nes at cwi.nl
Thu Dec 15 06:58:35 CET 2011


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 at 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 at sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20111215/7bab36a7/attachment.sig>


More information about the developers-list mailing list