Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BB8DE11579 for ; Thu, 19 Jun 2014 13:17:59 +0000 (UTC) Received: (qmail 2530 invoked by uid 500); 19 Jun 2014 13:17:58 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 2458 invoked by uid 500); 19 Jun 2014 13:17:58 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 2446 invoked by uid 99); 19 Jun 2014 13:17:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jun 2014 13:17:58 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [38.100.17.149] (HELO dc-dag1.bateswhite.com) (38.100.17.149) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jun 2014 13:17:52 +0000 Received: from DC-DAG1.bateswhite.com ([fe80::e5cc:7eac:2a49:4162]) by dc-dag2.bateswhite.com ([fe80::6cdc:91e2:45bb:e7a8%14]) with mapi id 14.01.0218.012; Thu, 19 Jun 2014 09:17:30 -0400 From: Clay McDonald To: user Subject: simple insert query question Thread-Topic: simple insert query question Thread-Index: Ac+LwNIYFUgvZs2zTFOJ49GtuJTaCw== Date: Thu, 19 Jun 2014 13:17:29 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.20.5.251] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org hi all, how do I write the following query to insert a note with a current system t= imestamp? I tried the following; INSERT INTO TEST_LOG VALUES (unix_timestamp(),'THIS IS A TEST.'); thanks, Clay