Re: help on sql

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 18 Nov 2009 16:19:17 +0100
Message-ID: <b79ee$4b041075$524b9d64$23639_at_cache6.tilbu1.nb.home.nl>



RA wrote:
> Hi sql gurus,
>
> I need some help and also curious on how to write this in single sql
> statement, requirements goes like this
>
> Table structure
> ================
> create table find_fixed_open (
> find number,
> fixed number,
> open number,
> bug_when date
> );
>
>
> Data
> =============
> insert into find_fixed_open values(5,3,2,'10/01/2009');
>-------------------------------------------^^^^^^^^^^

Aaaargghhhh! That NOT a date - it's a string! I read it as ten divided by one, divided by twothousandandnine

Promise to never, ever do that again! Typecast your data! You should have use the to_date function here!

-- 

Regards,
Frank van Bortel
Received on Wed Nov 18 2009 - 09:19:17 CST

Original text of this message