даты в SQL

← →
___X (2004-12-29 16:01) [0]

select
DS_Routes.DatePlan,
DS_Routes.ChangeDate,
DS_Faces.FName
from
DS_Routes inner join DS_Faces
on DS_Routes.fID = DS_Faces.fID
where
DS_Routes.DatePlan >=

как записать чтоб дата превосходила допустим 14.12.04 в MS Sql

← →
DimaK (2004-12-29 16:07) [1]

DS_Routes.DatePlan >= "14.12.2004"

← →
Соловьев © (2004-12-29 16:08) [2]

select
DS_Routes.DatePlan,
DS_Routes.ChangeDate,
DS_Faces.FName
from
DS_Routes inner join DS_Faces
on DS_Routes.fID = DS_Faces.fID
where
DS_Routes.DatePlan >= :p

ADOQuery.Parameters[0].Value := "20041214";

← →
___X (2004-12-29 16:29) [3]

DimaK Так не пройдет

← →
DimaK (2004-12-29 16:42) [4]

Извеняюсь...
Во что в хелпе нарыл:
SQL Server recognizes date and time data enclosed in single quotation marks (‘) in these formats:

Alphabetic date formats (for example, ‘April 15, 1998’)
Numeric date formats (for example, ‘4/15/1998’, ‘April 15, 1998’)
Unseparated string formats (for example, ‘19981207’, ‘December 12, 1998’)

даты в SQL Найти похожие ветки