sql

Question

sql

vikaskuncham

Grasshopper

Points: 11
More actions
April 23, 2012 at 12:35 am

#254622

how can i add timestamp columns in sqlserver

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

select getdate() as TimeStamp

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

vikaskuncham (4/23/2012)
how can i add timestamp columns in sqlserver

Please define what you mean by timestamp. There could be several answers to this question depending on what you are attempting to accomplish.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

It also depends on what you mean by "add." Are you referring to the Create Table statement or are you referring to adding the column to a resulting data set, or what?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.