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
Example:
2011-04-26 05:53:05.000 --> 20110426055305
2011-04-26 13:12:09.000 --> 20110426131209
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay got it working now. Thanks
ASKER
Apr 26 2011 553AM
I need for it to look like 201104260553.