BitShop LLC
Ashburn, VA
(703) 728-6831
Fax:
(703) 563-3826

EMail Us
 

 
Our Blogs
 
Loading BitShop News...
   
 
Morals
 

BitShop abides by: the Rotary International Four Way Test - Find out what that means..

   
 
NEXT STEP
 

To navigate our site click the menu at the top.

   
 
Non-BitShop Ads (Hold Control when you click)
 
Mar8

Written by:Steve Radich - Founder BitShop, Inc.
3/8/2012 4:41 PM 

 

Many times you need to convert from a YYYYMM date field to a date or datetime field - There's multiple ways to do this but this one meets most peoples needs and is simple..

update

TableName set field_date = convert(datetime,substring(update_period,5,2)+'/01/'+substring(update_period,1,4))

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment  Cancel 
 
Please Share Your Comments With Us
 



Submit Comment
Excellent Info0.00%0
Great Info0.00%0
Useful Info0.00%0
Not so useful0.00%0
Confusing / Useless0.00%0

Number of Comments0,Average of Ratings
No comment.
 
Network Status
 

ALL Servers
Operational


   
 
Learn More!
 

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us