October 2, 2003 at 5:54 am
it was not clear from the question whether LastUpdate column was timestap or datetime. In normal practise this is considered as datetime.
October 2, 2003 at 6:36 am
All I know is I tried it and I was able to get answer 2 and 3 to work.
October 2, 2003 at 6:59 am
Could you tell me how it was unclear? The schema was included in the question:
CREATE TABLE Customers(
PrimaryName varchar(30),
LastUpdate timestamp)
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
October 2, 2003 at 6:59 am
quote:
All I know is I tried it and I was able to get answer 2 and 3 to work.
Did you see the correct date and time or did you see 1900?
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
October 2, 2003 at 8:53 am
I got it wrong because I was keying on the phrase: 'format like this "2003-10-12 10:03:39.123"'
Answers 2 and 3 do give in that format although you will never get the right date.
What I wasn't looking at is the first part of that sentence: 'You want to determine when' which is asking for a specific date.
Good question, I thought you were trying to fool us. I ended up fooling myself.
October 2, 2003 at 1:47 pm
In this question it didn't matter, but in future can questions specify the format for dates. As different countries define date formats differently, and the American date format dates may confuse a few people eg getting the days and months the wrong way round.
Steven
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply