HELP DATE!

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by SG Mon, 19 Jan 1998 00:00

#38

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads