• kimberly_lehman (6/6/2014)


    Ask "Using T-SQL, how do you get the current date and time"?

    So would you consider this a valid answer? "I think it's CURRENT TIMESTAMP but if I was blanking on it I'd google it to be sure."

    I've worked with so many language that sometimes I mix them up, so I often google things even if I know them. And sometimes even when I "know" something, a quick search reminds me of something I forgot. IMO, knowing how to find the information you need is just as valuable as already knowing it. And double checking yourself is a good skill too. If you've never forgotten a simple piece of syntax, then you never had a baby who didn't sleep through the night.

    I believe GETDATE() is specific to T-SQL and CURRENT_TIMESTAMP is ANSI SQL function.

    I think still learning

    ***SQL born on date Spring 2013:-)