getting date part from a date time var

Anon

i want to get the date part of a date time variable from the query itself .is there any function for that.
there is a date time variable in the table let us say abc_time it's value is getdate
so if we are retriving that value by

select abc_time from table

it will return as 2002-05-03 12:02:28.000

i want the date part of that variable 2002-05-03

i want this for comparing this value with a date that user is entering through text box
here user is entering date only

can anybody tell me

Anon

u can give the Query
select abc_time(DD/MM/YYYY) from table
it will give u in the format 03-05-2002
u can change accordingly
hope it helps
bye

Anon

"date time variable", "date part", "getdate"...either you're referring to mssql or you use it often ;-)

Functions vary ffrom db server to db server. Which one do you need to run this query on?

Anon

it is showing that abc_time is not a recognized function name.

Anon

i am retrieving the datetime variable (sql-7)
from the table.this value am assigning in my asp page as
aaa=now()
and inserting this value to abc_time field of this table
but i want only the date part(20-5-2002)
from this variable while querying

Anon

which database are u using?

Anon

db is sql7.0

Anon

try this
select convert(varchar,abs_time,103)from table
hope this will work do reply me if it works
bye

Anon

ya... it is working
but it is giving in the form of 03/05/2002
but it is ok
a lot of thanks for your response
bye

bretticus

SELECT CAST(DATEPART(dd, abc_time) AS varchar(2)) + '-' + CAST(DATEPART(mm, abc_time) AS varchar(2)) + '-' + CAST(DATEPART(yyyy, abc_time) AS varchar(4)) AS dateformatted FROM table

possible problem: If you need month format 01 and/or day format 01 with the preceeding 0, this will not work.

bretticus

whoops, rearrange the datepart functions accordingly to fit your yyyy-mm-dd format.

bretticus

PS ;-) I have a ASP/VBScript DateFormat function so you can post aaa as a varchar with the current date in the proper format (which may be the easiest solution overall)