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.
SQL statement comparing date
Name: dougchiu Date: January 13, 2008 at 19:51:43 Pacific OS: Windows2000 CPU/Ram: 2 Product: 2
Comment:
May I ask if any sql statement to compare date with today and give the result on each record? e.g table Date Name 8/1/2008 Tom 27/12/2008 Ann 24/6/2007 Sam 17/8/2007 May
Compare with today which more than 30 days result Date Name Morethan30d 24/6/2007 Sam Yes 17/8/2007 May Yes
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for key 1. I have no idea what im doing wrong here. He...
Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has amount in numbers and i want to convert that amoun...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, the second one extracts the user information. I t...
