Re: SQL question: confused about dates

From: Bill Edwards (billedwards_at_msn.com)
Date: 01/26/05 

Date: Tue, 25 Jan 2005 23:32:43 -0600

see:

http://www.mvps.org/access/datetime/date0005.htm

"zladnaj" <zladnaj.1jg5hm@news.officefrustration.com> wrote in message
news:zladnaj.1jg5hm@news.officefrustration.com...
>
> 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: Is SQL procedural or non-procedural?
    ... SQL is both a data definition and manipulation language. ... it is declarative to support the data definition part. ...
    (comp.databases.theory)
  • SQL question: confused about dates
    ... I'm creating an Access db for a student project, but I've hit a snag. ... I have defined the 2nd and 3rd fields in a table as a DATE data type. ... Does anyone know how I express my date values in my SQL statement so ...
    (microsoft.public.access.gettingstarted)
  • Re: ALTER TABLE syntax
    ... Your db has to be SQL 92 compliant. ... > in constraint clause" message for the following: ... > Does Access support the addition of cascade deletes via Data Definition SQL? ...
    (microsoft.public.access.queries)
  • return the correct WW value
    ... I hit a snag while ... testing the serverPerformanceWeekly script. ... SQL> select to_char,'WW') from ...
    (comp.databases.oracle.misc)
  • Re: DataTable Limitations
    ... I think that you will hit computer's memory limit way before you'll hit any ... dataset limit. ... > We've currently got a "process" that takes de-normalized data from SQL ... > Server, transforms the data into normalized tables, ...
    (microsoft.public.dotnet.framework.adonet)
Loading