Re: datetime

Article View: borland.public.vdbase.data.sql

Article #834

Back to borland.public.vdbase.data.sql Previous Next

#834

From: zainal ag
Date: Sat, 25 Jul 1998 00:00

17 lines
1021 bytes

Romain Strieff [TeamB] wrote:
> Handle? With SQL?
> 
I am using SQL to retrive and update data to informix database, my
problem is
datetime field from informix display as today date. I can update the
datetime with 

  update informix set pptime='9:30' where mrn='123456'

but when I SQL select the record, pptime display today date 

> SELECT EXTRACT(YEAR FROM HIRE_DATE)  FROM EMPLOYEE
> 
I tried this but it gives server error: a syntax error has occurred.

zag

Technical Details

Message-ID: <35B933DB.6B88@medic.ukm.my>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35B82F26.51CA@medic.ukm.my> <MPG.1022a53f15e0f7e698b00e@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e9971370cc8cf784
X-Google-Attributes: gidff5a1,public
From: zainal ag <zag@medic.ukm.my>
Subject: Re: datetime
Date: 1998/07/25
Message-ID: <35B933DB.6B88@medic.ukm.my>
X-Deja-AN: 374686557
Content-Transfer-Encoding: 7bit
References: <35B82F26.51CA@medic.ukm.my> <MPG.1022a53f15e0f7e698b00e@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: HUKM
Mime-Version: 1.0
Reply-To: zag@medic.ukm.my
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message