Hi Stefan,
Nope, the name of the column is "deliveryDays" :)
Freddy
2010/10/25 Stefan Manegold <
Stefan.Manegold@cwi.nl>
> Hi Freddy,
>
> I don't think that the error you experience is triggered by the column
> type, but rather by the fact that your date column ha? a name - say "date" -
> that is a reserved key word in SQL an hence needs to be double-quoted
> according to the SQL standard (this is not a MonetDB specific choice, but a
> "feature" of the SQL standard) --- not knowing your table & column names, I
> can only guess, though ...
>
> Stefan
>
>
> ----- Oorspronkelijk bericht -----
> Van: Freddy Priyatna <
freddy.priyatna@gmail.com>
> Verzonden: maandag 25 oktober 2010 16:03
> Aan: MonetDB-users <
monetdb-users@lists.sourceforge.net>
> Onderwerp: [MonetDB-users] Querying date type column in MonetDB
>
> Dear All,
>
> I am new to MonetDB, so most likely my question will look obvious.
>
> I would like to ask, how can columns with date type is queried in monetdb.
> Based on my experience, it seems that date type columns need special
> treatment. It seems that the only way to query them is with the syntax
> "column_name" while other columns seems to work with the format
> table_name.column_name without the need of double quote. When I tried to
> query date column with the syntax table_name.column_name, it gave me an
> error "no such column"
>
> So my question is, is it true that the only way to query date columns is
> using "column_name" format? Another question will be, what happen if I need
> to query same name columns coming from different table?
>
> Thanks in advance,
> Freddy
>
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America
> contest
> Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in
> marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
>
http://p.sf.net/sfu/nokia-dev2dev
> _______________________________________________
> MonetDB-users mailing list
>
MonetDB-users@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users