SQL-question: how do i get the current date

out of an MS-SQL-Server?
i did this a while ago with oracle by using some kind of 'dummy-table', but a) i forgot how and b) it wont work with sql-server anyway

i tryed to search the MS-homepage, but i didnt find anything useful :/

SELECT CURRENT_TIMESTAMP
GO

?

that was fast and it works.
thank you

[hinch]

what a **** way of doing it

set the default value for the field to (getdate())

Originally posted by hinchles
what a **** way of doing it

set the default value for the field to (getdate())

Bear in mind i know bugger all SQL as ive never had to use it nor have i done db's at uni and i was quite happy with ^^ :p

Originally posted by Bigchiefweale


Bear in mind i know bugger all SQL as ive never had to use it nor have i done db's at uni and i was quite happy with ^^

that should make me worry about my education

[mbushell]

Originally posted by wu_trax
i tryed to search the MS-homepage, but i didnt find anything useful :/

I find drumming on a pigs belly whilst wearing rubber gloves, standing on my head with no trousers and letting my balls hang and eating mash potato as useful as the MS-homepage.

[Raging.Retard]

Originally posted by mbushell


I find drumming on a pigs belly whilst wearing rubber gloves, standing on my head with no trousers and letting my balls hang and eating mash potato as useful as the MS-homepage.

Then clearly you should have just intalled the 'Books Online' that come with all legitimate versions of MSSQL. That reference pretty much contains everything.

Whats more, is that hinch is even nearly correct Though you dont need to set a default value to it like he said. GetDate() is a function that can be used anywhere its needed in a TSQL statment.

K thx.