View Single Post

   
  #2 (permalink)  
Old 03-01-2008, 02:40 PM
rdraider
 
Posts: n/a
Default Re: Convert CHAR YYYYMMDD to mm/dd/yyyy

Correction the source field in an INT type
So how to convert INT type YYYYMMDD to a date mm/dd/yyyy


"rdraider" <rdraider@sbcglobal.net> wrote in message
news:7Unzi.11028$3x.3766@newssvr25.news.prodigy.ne t...
>I can't seem to find a method of converting a CHAR(8) column in the form of
>YYYYMMDD to an actual date such as mm/dd/yyyy
>
> Can anyone point me in the right direction?
>
> Thanks
>



Reply With Quote