pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ray Messier <messier@nichewareinc.com>
To: pgsql-sql@postgresql.org
Subject: date formation problems
Date: Sat, 19 Feb 2000 09:18:51 -0800
Message-ID: <NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com> (raw)



i have a table  ....

create table foo ( dfield datetime );

when i do an insert the date always comes out as 1969! any ideas why?

$cSQL = "INSERT INTO foo (dfield) VALUES ('" . date("m/d/Y h:m
a","12/09/2001 02:15 am") . "')";
pg_exec($oConn, $cSQL);

Attachments:

Ray Messier.vcf (text/x-vcard, 494B) download BEGIN:VCARD VERSION:2.1 N:Messier;Ray FN:Ray Messier ORG:Nicheware, Inc. TITLE:V.P. of Engineering NOTE:ICQ = 1549641 TEL;WORK;VOICE:(916) 797-6700 TEL;WORK;VOICE:(888) 428-7246 TEL;CELL;VOICE:(916) 870-5441 TEL;WORK;FAX:(916) 797-6767 ADR;WORK:;;1803 Cirby Way Ste 2;Roseville;CA;95661;USA LABEL;WORK;ENCODING=QUOTED-PRINTABLE:1803 Cirby Way Ste 2=0D=0ARoseville, CA 95661=0D=0AUSA URL: URL:http://www.nichewareinc.com EMAIL;PREF;INTERNET:rmessier@unicom-inc.com REV:19990923T202834Z END:VCARD

Message-ID: <NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com>
Permalink:  ../NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com/
Also on:    postgresql.org/message-id/NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: messier@nichewareinc.com
  Subject: Re: date formation problems
  In-Reply-To: <NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com>
  References: <NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox