asked on SQL - CONVERT or whatever is used to take txt field CUSTOM_FIELD and extract date and then use in WHERE statement
Table : PHM_ENHANCED_CHGS
Field : CUSTOM_FIELD
Data type : text
Example : 201503302304
Field is a date time stamp.
I need to be able to do whatever is needed to the field data and then do a WHERE date between here and here.
Field : CUSTOM_FIELD
Data type : text
Example : 201503302304
Field is a date time stamp.
I need to be able to do whatever is needed to the field data and then do a WHERE date between here and here.
Microsoft SQL ServerSQL
Last Comment
ghettocounselor
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Duh! sheesh, funny how sometimes you look at something and don't see the simplicity available. Thanks!
SELECT *
FROM YourTable
WHERE CONVERT(datetime, MyStringField) BETWEEN '2015-01-01' AND '2015-03-31 23:59:59.997'
If your fields do not have the time with the date, you can try this:
SELECT *
FROM YourTable
WHERE CONVERT(datetime, MyStringField) BETWEEN '2015-01-01' AND '2015-03-31'