SELECT column FROM table WHERE time = @time ISSUE

[Harvey Saayman]

Hey guys im having a slight problem with the above query, the problem is the value in the variable is like this "23:00" and the value in the table is "01-01-2008 23:00:00.000" how can i get the query to return the row i need irrespective of the date that is attached to the time? thanx,

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL think BIG and kick ASS

you.suck = (you.passion != Programming)

[Blue_Boy]

select convert(varchar(10),columnname,108) from myTable it will return this format HH:mm:ss hope it helps to you...

---

I Love T-SQL

[Sivu]

Hey man, You can use DATEPART to get the different parts of the date. select right('0' + convert(varchar, datepart(hh, time)), 2) + ':' + right('0' + convert(varchar, datepart(mi, time)), 2) + ':' + right('0' + convert(varchar, datepart(ss, time)), 2) With the date you've given as an example, this would return the string "23:00:00". Hope this helps...

[Harvey Saayman]

thanx dude, im sure it will work!

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL think BIG and kick ASS

you.suck = (you.passion != Programming)

[Sivu]

Oh, that's handy! i didn't know there was such easy conversion! :-D

[Blue_Boy]

I guess it will work for you ;)

---

I Love T-SQL

[Blue_Boy]

108 is returned format of datetime, also we have another formats like 100,101,102 and so on If you wanna check this syntax in T-SQL by changing format number select convert(varchar,getdate(),108)

---

I Love T-SQL

modified on Tuesday, April 22, 2008 6:09 AM

[Colin Angus Mackay]

Blue_Boy wrote:

108 is returned format of datetime, also we have another formats like 100,101,102 and so on

Which means what? What does format "101" actually mean? Without further explanation your statement is meaningless. Technically correct, but meaningless all the same.

Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Introduction to LINQ to XML (Part 1) - (Part 2) My website | Blog

[Blue_Boy]

for more-meaning use google search engine ;)

---

I Love T-SQL

[sonia sardana]

hey frnd can u tell me what is 108 in the foll Query select convert(varchar(10),columnname,108) from myTable