February 27, 2013 at 5:36 am
Hi all
I have a date which is in a text file which looks like this '25/02/12 11:39:34'
I have been playing around with CONVERT so I can insert it into a DATETIME field of a database but I keep getting conversion errors.
Does anyone have any suggestions on how I can do this?
Thanks
February 27, 2013 at 5:42 am
SET DATEFORMAT DMY
SELECT CONVERT(datetime, '25/02/12 11:39:34')
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
February 27, 2013 at 7:37 am
Oh right - thanks very much 🙂
February 27, 2013 at 8:30 am
This would work as well:
SELECT CONVERT(datetime, '25/02/12 11:39:34', 3)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply