HELP DATE!

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

Article #38

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

#38

From: SG
Date: Mon, 19 Jan 1998 00:00

14 lines
957 bytes

Hi, all!
Help me please with date() selection from Access table.
1) If I want to retrieve from in_date field (with date/time type) only
last week (last month) data, how looks SELECT clause? SYSDATE not
accepted. 
2) How to change date format to short in IB for easier serching in
database?
3) How can I write 19th Jan (that looks like 0/19/98 in IB) into the
Access table, then retreive and show right date(1/19/98) in component of
the form?
If you have any suggestions, answer please.

SG

Technical Details

Message-ID: <34C2FC7A.1CD4@impar.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,f43bbc5c0abbeb22,start
X-Google-Attributes: gid101d9a,public
From: SG <svegan@impar.com>
Subject: HELP DATE!
Date: 1998/01/19
Message-ID: <34C2FC7A.1CD4@impar.com>
X-Deja-AN: 317274934
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Reply-To: svegan@impar.com
Content-Type: text/plain; charset=us-ascii
Organization: None
Newsgroups: borland.public.intrabuilder.data.sql