Does anyone know if there is a standard way to format dates in a query? By standard I mean works in multiple databases (ie Oracle, SQL Server, etc).<BR><BR>SELECT * FROM MYTABLE WHERE MYDATE = ????<BR><BR>I've always used '#10/11/2000#' (or something like that I think) with Microsoft stuff, but that doesn't work if you leave the MS world. Anyone know?