View Single Post
  #1 (permalink)  
Old March 4th, 2004, 04:14 PM
isheikh isheikh is offline
Authorized User
 
Join Date: Feb 2004
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data type in MSDE

Hi,

I am using msde with asp. In my asp page I am geting the date like
dim addate
addate =date

which give me date in this format mm/dd/yyyy

Now I need to insert this date into my msde table, what data type should I use. I tried datetime and it did not work , when I go to my table all I see 12.00 PM.

Thanks