SQL, Insert Date

Thread View: borland.public.cppbuilder.database.ado

2 messages

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

2 total messages Started by Jorge Leibowich Thu, 08 Feb 2001 17:04

#5767

Author: Jorge Leibowich
Date: Thu, 08 Feb 2001 17:04

11 lines
1392 bytes

I'm trying to insert or select a date in a paradox database with Tquery
Object, but NOTHING!! Only errors, I'm tryied ALL

Select * from xxx where TheDate = '10/10/10'
Select * from xxx where TheDate = 10/10/10
Select * from xxx where TheDate = #10/10/10#
Select * from xxx where TheDate = ?10/10/10?
Select * from xxx where TheDate = :10/10/10:

And nothing works, are there an especial way to manage dates or time fields?
And with TimeStamp fields?

Re: SQL, Insert Date

#5770

Author: Yuancai (Charlie) Ye
Date: Thu, 08 Feb 2001 17:35

22 lines
1699 bytes

Hi,
    Use a parameterized statement instead.

Yuancai (Charlie) Ye
See 27 OLEDB examples at http://www.geocities.com/oledbpro

"Jorge Leibowich" <jorge@lid.com.ar> wrote in message
news:3a82d19e_1@dnews...
> I'm trying to insert or select a date in a paradox database with Tquery
> Object, but NOTHING!! Only errors, I'm tryied ALL
>
> Select * from xxx where TheDate = '10/10/10'
> Select * from xxx where TheDate = 10/10/10
> Select * from xxx where TheDate = #10/10/10#
> Select * from xxx where TheDate = ?10/10/10?
> Select * from xxx where TheDate = :10/10/10:
>
> And nothing works, are there an especial way to manage dates or time
fields?
> And with TimeStamp fields?
>
>

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