Using the dot(.) with dates in Local SQl

selma...@cc.hut.fi (Selim H. Aygar)

Delphi Developer

Mon, 08 Feb 1999 03:00:00 GMT

Using the dot(.) with dates in Local SQl

Hi everyone,

Has anyone got the dot (.) separator for dates to work with Local SQL?

We use the date format dd.mm.yy in our databases so I need to make a query
like this work:

SELECT purchase_date, part_name FROM parts
WHERE purchase_date = 11.11.95

but it won't work because SQL thinks the dot is a special symbol used to
separate tables and columns. Defining the date separator to be a dot (.) in
the BDE doesn't help.

Any ideas?

Thanks a lot.

Sami.
selma...@vipunen.hut.fi
Systems Analysis Lab
Helsinki Univ. of Technology
02150 Espoo, Finland.

Mark Pritchar

Delphi Developer

Tue, 09 Feb 1999 03:00:00 GMT

Re:Using the dot(.) with dates in Local SQl

Quote

Selim H. Aygar wrote:

> Hi everyone,

> Has anyone got the dot (.) separator for dates to work with Local SQL?

> We use the date format dd.mm.yy in our databases so I need to make a query
> like this work:

> SELECT purchase_date, part_name FROM parts
> WHERE purchase_date = 11.11.95

Try

SELECT purchase_date, part_name FROM parts
WHERE purchase_date = "11.11.95"

--
Mark.

Other Threads

1. Local SQL - problem with query using a DATE

2. Using LOCAL-SQL or Transact-SQL with SQL-server and BDE

3. Local SQL, works in MS SQL, not in local SQL

4. Local SQL challenge - for all you local SQL gurus:

5. Date Format & Local SQL

6. Local SQL and dates

7. How do you find a blank date field with Local Sql

8. Local SQL and Dates

9. Date formats in local SQL

10. Local SQL Date/Time-related operations