Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 36586 invoked from network); 19 Nov 2006 21:47:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Nov 2006 21:47:07 -0000 Received: (qmail 21260 invoked by uid 500); 19 Nov 2006 21:47:16 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 21234 invoked by uid 500); 19 Nov 2006 21:47:16 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 21223 invoked by uid 99); 19 Nov 2006 21:47:16 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Nov 2006 13:47:16 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [203.217.22.128] (HELO file1.syd.nuix.com.au) (203.217.22.128) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Nov 2006 13:47:03 -0800 Received: from [192.168.222.102] (host102.syd.nuix.com.au [192.168.222.102]) by file1.syd.nuix.com.au (Postfix) with ESMTP id 8DE0CB7626 for ; Mon, 20 Nov 2006 08:46:18 +1100 (EST) Message-ID: <4560D157.2050201@nuix.com> Date: Mon, 20 Nov 2006 08:49:11 +1100 From: Daniel Noll Organization: NUIX Pty Limited User-Agent: Thunderbird 3.0a1 (Windows/20061117) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Date - Timestamp format for inserts? References: <0b8001c70c10$878cf340$6401a8c0@matkins> In-Reply-To: <0b8001c70c10$878cf340$6401a8c0@matkins> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Marl Atkins wrote: > What's wrong with this statement? > INSERT INTO users > (RecordID,CTMCClientID,OrgName,Prefix,FName,MidInit,LName,Addr1,Addr2,City,S > tate,Zip,Phone,CellPhone,AltPhone,Fax,Email,Login,Password,Status,AccessLeve > lID,DateCreated,CreatedBy,DateExpired ) VALUES(1,NULL,'SoftLink Systems, > Inc.',NULL,'Marl',NULL,'Atkins',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL > ,NULL,'marl','marl',0,1,'2006-09-10-00',1,'2050-01-01-00' ) Is there any particular reason you're not doing this the normal way? (i.e. using ? and then setTimestamp(int,Timestamp)) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699 Web: http://nuix.com/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this message or attachment is strictly prohibited.