Very thanks Scott!! this is the solution was need :)
Jordi
On 19 mayo, 23:36, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> On Mon, May 19, 2008 at 4:51 AM,jrivero<[EMAIL PROTECTED]> wrote:
> > Hi, i need help for a query. I have three fields, year, month and day
> > into table and need join and u
On Tue, May 20, 2008 at 5:34 AM, Sam Mason <[EMAIL PROTECTED]> wrote:
> On Mon, May 19, 2008 at 03:36:39PM -0600, Scott Marlowe wrote:
> > On Mon, May 19, 2008 at 4:51 AM, jrivero <[EMAIL PROTECTED]> wrote:
> > > My problem is not that make update query.
> > >
> > >> update table set date=(select
On Mon, May 19, 2008 at 03:36:39PM -0600, Scott Marlowe wrote:
> On Mon, May 19, 2008 at 4:51 AM, jrivero <[EMAIL PROTECTED]> wrote:
> > My problem is not that make update query.
> >
> >> update table set date=(select year || '-' || month || '-' || day || '
> >> 01:00:00' as newdate from table)
>
On Mon, May 19, 2008 at 4:51 AM, jrivero <[EMAIL PROTECTED]> wrote:
> Hi, i need help for a query. I have three fields, year, month and day
> into table and need join and update another field named date on same
> table.
>
> My problem is not that make update query.
>
> With this query have the valu
Is there a good reason to NOT store the year month and day as a date
instead of this way?
I can think of a lot of very good reasons to store it as a date, not a
lot of reasons to store them broken apart.
On Mon, May 19, 2008 at 4:51 AM, jrivero <[EMAIL PROTECTED]> wrote:
> Hi, i need help for a q
Hi, i need help for a query. I have three fields, year, month and day
into table and need join and update another field named date on same
table.
My problem is not that make update query.
With this query have the value of the update:
> select year || '-' || month || '-' || day || ' 01:00:00' as n
