>Hi There,
>
>I was wondering if you could help me.
>
>I have a table called "Username" and in that table i am a field called "DOB" which holds the date of birth of all the users. I was wondering wat is the syntax i should use in Command runner to retrieve a particular date from that table. Thanx for the help in advance.
Bilal,
Prefer clear date expressions as already expressed by Mike,Robert and Sergey.
select * from myTable where DOB = {^1961/1/19}
or:
select * from myTable where DOB = date(1961,1,19)
Both mean Jan 19th, 1961 whereever you're and whatever your date settings are.
Cetin