Format for Date.

From: Phoebe. (phoebe8124_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 14:52:01 +0800

Hi, Good Day!

In my SQL database, my PostedDate's datatype is not Date/Time but integer
for eg. 20040310

I'd like to show the date in this format --> 10/03/2004 in my datagrid, so
how can i do tht?

Can someone help?
Thanks in advanced.

rgds,
Phoebe.

Relevant Pages

  • Format for Date.
    ... my PostedDate's datatype is not Date/Time but integer ... how can i do tht? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Date/Time datatype in Access 2003 affects date/time duplicate
    ... To reiterate what many responses have told you -- Access has a Date/Time ... It does not have a "Time" datatype. ... > "Medium Time" setting does not hide the date from my queries. ... >>> The files are imported by a windows service we had written. ...
    (microsoft.public.access.queries)
  • Re: SQL Order by Date `Date` column CAP ATTACHED 32kb
    ... > My datatype was originally Date/Time, so avail, so changed the datatype to ... you just rephrased your original question. ... diagnosing your original problem. ...
    (microsoft.public.vb.general.discussion)
  • Re: Date filtering
    ... changing the field to a Date/Time format. ... Date/Time is a datatype. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • RE: Query by dates
    ... Datatype is Date/Time. ... Database was designed in Access97. ... Jerry Whittle wrote: ...
    (microsoft.public.access.queries)
Loading