Hey guys,
I have a file that has date formatted like so: 2006-11-16 20:12:00
I would like the dateformat to be like mm/dd/yyy hh:mm
The file is being pulled into a varchar field.... as 2006-11-16 20:12:00
when I do a conversion i can only get it to mon 11,2006
any suggestionsStop loading it into a varchar field. Load it into a datetime column so you can display it however you want.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment