|Summary:||SQL: Implement complementary EXTRACT functionality|
|Product:||SQL||Reporter:||Stefan de Konink <skinkie>|
|Component:||all||Assignee:||SQL devs <bugs-sql>|
|Attachments:||UNIX_TIMESTAMP SQL function to convert a timestamp into an epoch|
Description Stefan de Konink 2009-10-05 14:05:52 CEST
PostgreSQL implements a nice number of extract features that can be used as DATEPART. We don't have these functions yet so it could be useful to implement them. (I'll volunteer) http://www.postgresql.org/docs/7.4/static/functions-datetime.html (section 9.8.1)
Comment 1 Fabian Groffen 2009-12-01 09:52:55 CET
This seems like a useful addition to the codebase to me
Comment 2 Fabian Groffen 2009-12-01 11:13:59 CET
we should at least implement EPOCH (1752627)
Comment 3 Pseudo user for Sourceforge import 2010-05-04 09:32:09 CEST
This bug was previously known as tracker item 2872897 at http://sourceforge.net/support/tracker.php?aid=2872897 The original assignee of this bug does not have an account here. Reassigning to the default assignee for the component, firstname.lastname@example.org. Previous assignee was email@example.com.
Comment 4 Fabian Groffen 2010-10-28 15:44:28 CEST
I'm affraid we won't make the EPOCH implementation for Oct2010
Comment 5 Sjoerd Mullender 2011-07-29 11:00:03 CEST
Apr2011-SP2 has been released.
Comment 6 Sjoerd Mullender 2011-09-16 15:10:37 CEST
The Aug2011 version has been released.
Comment 7 Sjoerd Mullender 2012-08-24 14:55:55 CEST
Jul2012-SP1 has been released.
Comment 8 Dennis Pallett 2014-07-16 11:09:05 CEST
Created attachment 290 [details] UNIX_TIMESTAMP SQL function to convert a timestamp into an epoch
Comment 9 Dennis Pallett 2014-07-16 11:10:36 CEST
I would also like to have this included into a future release of MonetDB. At the moment I'm using a simple SQL function that converts a timestamp into an EPOCH timestamp but it'd be better if it's properly implemented as part of the EXTRACT function.