Re: ADO Access select problem

From: "Jeche Frijdel" <jfrijdel@xxxxxxxxxxx>
Date: Mon, 18 Jul 2005 12:52:29 +0100

when I say in a text field I mean is numeric like 39808.3443 not dd/mm/yyyy
sorry should have been cleared.

"Jeche Frijdel" <jfrijdel@xxxxxxxxxxx> wrote in message
news:qMSdnUcOG9F7CUbfRVnyiw@xxxxxxxxxxxxxxxxx
>I need your help: don't think this is possible but hope you can prove me
>wrong.
>
> I am modifying a program and unable to change data structures (AARGH), the
> programmer has stored the DateTime in a text field, I need to pull this
> directly out from the table to a data-aware component
>
> In Informix sql I can use select Fieldname:DataType to select in a
> different format (if compatible) does access have something similar?
>
> I thought the following might work but doesn't
>
> select Atype as DateTime
> from prices
> where item = "Closed"
> order by Atype
>
> any help gratefully recieved...
>
> Thanks for looking
>
> Jeche
>

.

References:
- ADO Access select problem
  - From: Jeche Frijdel

Prev by Date: Re: database changes location crashes Delphi
Next by Date: Re: Access DB for Multi-user
Previous by thread: ADO Access select problem
Next by thread: Re: database changes location crashes Delphi
Index(es):
- Date
- Thread

Relevant Pages

ADO Access select problem
... I am modifying a program and unable to change data structures, ... select Atype as DateTime ...
(borland.public.delphi.database.ado)
Re: ASP.NET web application - date conversions UK date format?
... writting that you retrieve the date as dd/mm/yyyy; ... from a British date a datetime value. ... Dim dt As dateTime = System.DateTime.ParseExact(assessmentDate, ... Dim assessmentDate As Date ...
(microsoft.public.dotnet.languages.vb)