I'm sure that I'm missing some fundamental bit, but it seems like it should work. The CAST function converts one data type to another compatible data type. SELECT CAST(SUBSTRING('T00:00:00-06:00', 1, 19) AS datetime) AS Expr1 The PostgreSQL formatting functions provide a powerful set of tools for converting various data types (date/time, integer, floating point, numeric) to formatted strings and for converting from formatted strings to specific data types. That gives the same conversion error, but this works. isstrict An optional Boolean value that specifies whether an error is returned if an input date value is out of range. For a list of valid day, month, and year formats, see Datetime format strings. (DateTime BETWEEN CONVERT(datetime, SUBSTRING('T00:00:00-06:00', 1, 19)) AND ) format A string literal that defines the format of the input string, in terms of its date parts. SQL Server table: Id DateTime Ip City State Country Continent UserAgentġ T17:58:45-06:00 68.55.34.32 Laurel Maryland United States North America NULLĢ T17:58:52-06:00 70.88.57.62 Port Charlotte Florida United States North America NULLģ T17:59:06-06:00 71.3.202.110 Cape Coral Florida United States North America NULLĤ T17:59:23-06:00 67.239.18.161 Naples Florida United States North America NULLĥ T17:59:58-06:00 96.19.107.135 Gulfport Mississippi United States North America NULL I'm trying to do a query that gets some year-to-date results with BETWEEN DateTime field AND NOW(). You can specify one of the standard date and time format specifiers or a combination of the custom format specifiers. After this, we are using the Convert () function to change the date data type result to varchar of length 6. The first parameter is the string and the second is the date time. When a string that isn't one of the forms specified is passed to this method, a FormatException is thrown. SELECT '' AS 'String', CONVERT (varchar (6), CAST ('' as date), 112) AS yyyymm In the query above, we are converting the string to a date data type by using the Cast () function. Using strptime(), date and time in string format can be converted to datetime type. Our website logs that data and I don't really have control over it (I'm sure a proper datetime column would be preferable). The DateTime.ParseExact method converts a string to a DateTime object if it conforms to one of the specified string patterns. I have a Microsoft SQL Server 2008 R2 database where the DateTime column is not a datetime data type, but varchar(50).

Convert string to datetime sql