Link to home
Start Free TrialLog in
Avatar of holemania
holemania

asked on

SQL Query - parse string

I need help parsing a date so that it is in the format I need it to be for sql query.

Example:
2011-04-26 05:53:05.000   -->  20110426055305
2011-04-26 13:12:09.000   -->  20110426131209


SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of holemania
holemania

ASKER

When I use the replace my date isn't number any more, but it's looking like the following:

Apr 26 2011 553AM

I need for it to look like 201104260553.
Okay got it working now.  Thanks