SQL GETDATE()

[Patty]

Please help a noob here

So I got a fairly basic understanding of SQL. I have an Afrihost hosting packing with SQL 5.1. In PhpMyAdmin I run a simple query SELECT NOW() and it returns a result. However when I run SELECT GETDATE() I get the following error: #1305 - FUNCTION dbname_db.GETDATE does not exist

Should the results be the same?

I'm suspecting that this database doesn't have a lot of functions?

Thanks

 

[poffle]

MySQL doesnt have the function GetDate().

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

 

[GarethC]

You can use CURRENT_TIMESTAMP ()

 

[Patty]

Thanks for reply! So where does GetDate() come from then, because I often come across it on the net being used within SQL?

 

[Ianvn]

Its actually part of Transact SQL which will only work on Microsoft SQL (MSSQL)

http://msdn.microsoft.com/en-us/library/ms188383.aspx

 

[poffle]

Its actually part of Transact SQL which will only work on Microsoft SQL (MSSQL)

http://msdn.microsoft.com/en-us/library/ms188383.aspx

This.

MySQL and MS SQL are 2 totally different programs

 

[Patty]

Thanks Gents!