Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
getdate() in SQL w/out time
Name: Andy Date: June 5, 2003 at 11:22:37 Pacific OS: Win 2k CPU/Ram: gig
Comment:
Is there a way to run the getdate() function in SQL and omit the time part of it? I just want the date as 06/05/2003.
Name: abolk Date: June 5, 2003 at 12:05:18 Pacific
Reply:
Is there a way of doing this without having to convert it to a char? I would like to keep it in a date format. I'm trying to set a default value for a column in a table to be equal to the current date.
I am dumping information into a table with DTS. I want the date field to show the date and not the time, as I am comparing it to data in another table that just shows the date.
Summary: Is there a way to format the output of the getdate() function in SQL? I'm trying to compare it to a field where the data is stored as mmmyy. Thanks ...
Summary: I'm getting duplicate rows when I joined three tables in SQL 2000. Table 1: employee fields: last name,first name,ssn,rec_num Table 2: hepatits date1,date2,date3,employee references rec_num in employe...
0 
