a query suing Time format
-
Hi, I want to know the row(s) in which a Time Field is = to 15h00 : I've tried this but it doesn't work. SELECT * FROM MyTable WHERE TimeField=#15:00# ; have you got an idea ? BrutalDeath0
Brutaldeath0 wrote: a query suing Time format I want to know the row(s) in which a Time Field is = to 15h00 I'm not a lawyer - but you could try for a John Doe lawsuit. ;P
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871)
-
Hi, I want to know the row(s) in which a Time Field is = to 15h00 : I've tried this but it doesn't work. SELECT * FROM MyTable WHERE TimeField=#15:00# ; have you got an idea ? BrutalDeath0
Okay, it's been a long day... Here is a more serious answer.... SELECT * FROM MyTable WHERE datepart(hour, TimeField) = 15
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871)
-
Hi, I want to know the row(s) in which a Time Field is = to 15h00 : I've tried this but it doesn't work. SELECT * FROM MyTable WHERE TimeField=#15:00# ; have you got an idea ? BrutalDeath0
why not just use the LIKE clause. LIKE '15h00'. aren't dates stored as varchars, if not then you'd need to cast somehow. im just giving this advice from a programmers perspective