Thread: converting varchar date strings to date

converting varchar date strings to date

From

"pw"

Date:

14 October 2003, 17:00:45

Hello,

How can I typecast a date generated from VARCHAR fields into
a date field

ie:

UPDATE inventory SET date_field = vc_year||'-'||vc_month||'-'||vc_day;



where the date string is built up from varchar fields?

Thanks for any help.

Peter

Re: converting varchar date strings to date

From

Richard Huxton

Date:

14 October 2003, 17:30:46

On Tuesday 14 October 2003 17:54, pw wrote:
> Hello,
>
> How can I typecast a date generated from VARCHAR fields into
> a date field
>
> ie:
>
> UPDATE inventory SET date_field = vc_year||'-'||vc_month||'-'||vc_day;

... SET date_field = CAST(vc_year...vc_day AS date)
or
... SET date_field = (vc_year...vc_day)::date

The first is SQL-standard, the second less typing.

If that gives you problems, cast to text first, then to date.

--
  Richard Huxton
  Archonet Ltd

Re: converting varchar date strings to date

From

Peter Eisentraut

Date:

14 October 2003, 18:14:42

pw writes:

> How can I typecast a date generated from VARCHAR fields into
> a date field

Using CAST().

--
Peter Eisentraut   peter_e@gmx.net

Re: converting varchar date strings to date

From

"pw"

Date:

14 October 2003, 18:39:02

Hello,

This has been resolved.
As I told a previous poster, CAST() wasn't working.
I have no idea why.

I finally used:

UPDATE inventory SET date_field=date(vc_year||'-'||vc_month||'-'||vc_day );

Peter


> pw writes:
>
> > How can I typecast a date generated from VARCHAR fields into
> > a date field
>
> Using CAST().
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>