I have a table calendar in sql 2000
it has 1 column named "dt" storing date the format of storing a date is
' 2004-02-02 00:00:00 '
now in 1 stored procedure i need to extract data based on todays date and then matching it dt column
when i get todays date using getdate() it is in different format
' Jan 28 2007 10:52AM '
how do i change this format matching to my stored format.
my second question is how i can just retrieve date part from ym dt column ?