Documenting date time functionality in MonetDB
I am currently working on documenting date/time functionality that exists in MonetDB and I have run into some problems/questions. I hope someone can help me out: 1) According to the Temporal Types page (https://www.monetdb.org/Documentation/SQLreference/Temporal), there should be a type 'daytime'. However, the following fails: create table t (b daytime);-> type (daytime) unknown in: "create table t (b daytime)" Does anyone know whether this feature has been removed or that this is a bug (or that I am perhaps missing something)? 2) Converting strings to dates works like a charm: *SELECT str_to_date('23-09-1987', '%d-%m-%Y');*-> 1987-09-23 But how about converting strings to times/timestamps: *SELECT str_to_date('11:40', '%H:%M');* -> null I can not seem to find any definitions of built in functions that take a string and produce anything other than a date. Thanks in advance! Robin PS: I am running the latest default branch on Ubuntu 14.04.
On Fri, May 22, 2015 at 03:05:58PM +0200, Robin Cijvat wrote:
I am currently working on documenting date/time functionality that exists in MonetDB and I have run into some problems/questions. I hope someone can help me out:
1) According to the Temporal Types page (https://www.monetdb.org/ Documentation/SQLreference/Temporal), there should be a type 'daytime'. However, the following fails:
create table t (b daytime); -> type (daytime) unknown in: "create table t (b daytime)" daytime is the mal level type for the sql type time.
Niels
Does anyone know whether this feature has been removed or that this is a bug (or that I am perhaps missing something)?
2) Converting strings to dates works like a charm:
SELECT str_to_date('23-09-1987', '%d-%m-%Y'); -> 1987-09-23
But how about converting strings to times/timestamps:
SELECT str_to_date('11:40', '%H:%M'); -> null
I can not seem to find any definitions of built in functions that take a string and produce anything other than a date.
Thanks in advance! Robin
PS: I am running the latest default branch on Ubuntu 14.04.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, 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: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
On Fri, May 22, 2015 at 03:05:58PM +0200, Robin Cijvat wrote:
I am currently working on documenting date/time functionality that exists in MonetDB and I have run into some problems/questions. I hope someone can help me out:
1) According to the Temporal Types page (https://www.monetdb.org/ Documentation/SQLreference/Temporal), there should be a type 'daytime'. However, the following fails:
create table t (b daytime); -> type (daytime) unknown in: "create table t (b daytime)"
Does anyone know whether this feature has been removed or that this is a bug (or that I am perhaps missing something)?
2) Converting strings to dates works like a charm:
SELECT str_to_date('23-09-1987', '%d-%m-%Y'); -> 1987-09-23
But how about converting strings to times/timestamps:
SELECT str_to_date('11:40', '%H:%M'); -> null we have str_to_time and timestamp now in default.
Niels
I can not seem to find any definitions of built in functions that take a string and produce anything other than a date.
Thanks in advance! Robin
PS: I am running the latest default branch on Ubuntu 14.04.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, 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: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
That's perfect. Thanks Niels! On 22-05-15 19:13, Niels Nes wrote:
On Fri, May 22, 2015 at 03:05:58PM +0200, Robin Cijvat wrote:
I am currently working on documenting date/time functionality that exists in MonetDB and I have run into some problems/questions. I hope someone can help me out:
1) According to the Temporal Types page (https://www.monetdb.org/ Documentation/SQLreference/Temporal), there should be a type 'daytime'. However, the following fails:
create table t (b daytime); -> type (daytime) unknown in: "create table t (b daytime)"
Does anyone know whether this feature has been removed or that this is a bug (or that I am perhaps missing something)?
2) Converting strings to dates works like a charm:
SELECT str_to_date('23-09-1987', '%d-%m-%Y'); -> 1987-09-23
But how about converting strings to times/timestamps:
SELECT str_to_date('11:40', '%H:%M'); -> null we have str_to_time and timestamp now in default.
Niels
I can not seem to find any definitions of built in functions that take a string and produce anything other than a date.
Thanks in advance! Robin
PS: I am running the latest default branch on Ubuntu 14.04. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Niels Nes -
Robin Cijvat