query: How do I CAST a date in a subquery? Currently getting an error: Conversion failed when converting date and/or time from character string
positive_passages.docid: 37669
positive_passages.text: Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail
negative_passages.docid: 138057
negative_passages.text: CAST throwing error when run in stored procedure but not when run as raw query
negative_passages.docid: 64663
negative_passages.text: Is there a way to get DateTime value from timestamp type column?
negative_passages.docid: 22481
negative_passages.text: How to use EntityFieldQuery with dates?
negative_passages.docid: 97864
negative_passages.text: UPDATE table using a subquery in SQLite
negative_passages.docid: 27527
negative_passages.text: How to return only the Date from a SQL Server DateTime datatype
negative_passages.docid: 11954
negative_passages.text: What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?
negative_passages.docid: 150013
negative_passages.text: Java: creating a date object from a string and inserting into MySQL
negative_passages.docid: 153534
negative_passages.text: Trouble with date substraction in Oracle
negative_passages.docid: 112480
negative_passages.text: Can't default date to CURRENT_TIMESTAMP in MySQL 5.5
negative_passages.docid: 26824
negative_passages.text: conversion of high_value to date datatype
negative_passages.docid: 103375
negative_passages.text: GetDate() function and this query are correct?
negative_passages.docid: 152492
negative_passages.text: The specified type member 'Date' is not supported in LINQ to Entities Exception
negative_passages.docid: 37566
negative_passages.text: How to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?
negative_passages.docid: 117527
negative_passages.text: sql server - passing unquoted constants to functions like DATEPART does
negative_passages.docid: 73100
negative_passages.text: How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
negative_passages.docid: 68131
negative_passages.text: Postgresql Date type and java SimpleDateFormat