Thread: Re: [GENERAL] Date time insertion

I use '1999-04-21 21:23:21' type format with sucess.

Regards

-----Original Message-----
From: Bob Kruger <bkruger@mindspring.com>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>;
pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
Date: Thursday, 24 June 1999 07:07
Subject: [GENERAL] Date time insertion


>
>I am trying to insert both the date and the time into a datetime field.
>
>If the field datetime in table v1 is dt, then the following successfully
>inserts the date into the datetime field:
>
>insert into v1 (date) values ('19990401') ;
>
>However, if I also wanted to retain the time of day, the following does not
>work:
>
>insert into v1 (date) values ('199904011530') ;
>
>Any hints?
>
>Thanks in advance.
>
>Regards - Bob Kruger
>
>

On Thu, 24 Jun 1999, John Huttley wrote:

    None of this matters in a date field, date != datetime

// I use '1999-04-21 21:23:21' type format with sucess.
//
// Regards
//
// -----Original Message-----
// From: Bob Kruger <bkruger@mindspring.com>
// To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>;
// pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
// Date: Thursday, 24 June 1999 07:07
// Subject: [GENERAL] Date time insertion
//
//
// >
// >I am trying to insert both the date and the time into a datetime field.
// >
// >If the field datetime in table v1 is dt, then the following successfully
// >inserts the date into the datetime field:
// >
// >insert into v1 (date) values ('19990401') ;
// >
// >However, if I also wanted to retain the time of day, the following does not
// >work:
// >
// >insert into v1 (date) values ('199904011530') ;
// >
// >Any hints?
// >
// >Thanks in advance.
// >
// >Regards - Bob Kruger
// >
// >
//
//
//

--
Principal Member Technical Staff, beyond.com    The world is watching America,
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __

dustin sallings wrote:
>
> On Thu, 24 Jun 1999, John Huttley wrote:
>
>         None of this matters in a date field, date != datetime
>
> // I use '1999-04-21 21:23:21' type format with sucess.

> // >
> // >I am trying to insert both the date and the time into a datetime field.
> // >
> // >If the field datetime in table v1 is dt, then the following successfully
> // >inserts the date into the datetime field:
> // >
> // >insert into v1 (date) values ('19990401') ;
> // >
> // >However, if I also wanted to retain the time of day, the following does not
> // >work:
> // >
> // >insert into v1 (date) values ('199904011530') ;
> // >
> // >Any hints?

That's what the reference manual has to say :

There are several ways to affect the appearance of date/time types:

      The PGDATESTYLE environment variable used by the backend directly
on postmaster startup.
      The PGDATESTYLE environment variable used by the frontend libpq on
session startup.
      SET DateStyle SQL command.

Chris
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow                 E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services    Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~