SQL question: confused about dates

From: zladnaj (zladnaj.1jg5hm_at_news.officefrustration.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 22:16:42 +0000

I'm creating an Access db for a student project, but I've hit a snag. I
have to use SQL insert statements.

I have defined the 2nd and 3rd fields in a table as a DATE data type.

Here is my statement:
INSERT INTO TRIP
VALUES (263,2005-01-18,2005-01-19,'Phoenix','AZ','4023892991',3);

But when I then go to the table, Access renders it like this:

263 | 6/8/1905 | 6/7/1905 | Phoenix | AZ | 4023892.......

Does anyone know how I express my date values in my SQL statement so
that they look like US-English dates, i.e. (1/18/05)?

Or, is the problem with the data definition - that I've defined these
fields as the DATE data type when they should be something else? 

-- 
zladnaj

Relevant Pages

  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Type Mismatch Error Message
    ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
    (microsoft.public.frontpage.programming)
  • Re: DISP_E_TYPEMISMATCH with OWC11
    ... you think its related to what data type OWC is expecting from the SQL ... I have a SQL ... Dim objChartspace, objChart, c, objConn, objRS, axis, sql ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.office.developer.web.components)
  • Re: Cant believe it - Back Again Already! - How to set variables to Type in SQL Statement?
    ... "Marshall Barton" wrote in message ... >>the way to set the SQL variables to assume the data types of the field. ... >>would allow it to assume the data type of the field to update to. ... > strSQLUpdate = strSQLUpdate _ ...
    (microsoft.public.access.modulesdaovba)
  • Re: From BAD To WORSE: A Disasterous Delete
    ... > DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS ... Tibor Karaszi, SQL Server MVP ... > mysterious deletion of ALL RECORDS, but now with the smaller data extract. ...
    (microsoft.public.sqlserver.server)