{"id":23,"date":"2009-12-10T03:47:18","date_gmt":"2009-12-10T08:47:18","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=23"},"modified":"2011-09-26T21:51:56","modified_gmt":"2011-09-27T02:51:56","slug":"how-to-find-datbase-version-using-sql-query","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2009\/12\/how-to-find-datbase-version-using-sql-query\/","title":{"rendered":"How to find out datbase version using SQL query"},"content":{"rendered":"

DB2 <\/strong><\/p>\n

`SELECT<\/span> versionnumber<\/span>,<\/span>
\nversion_timestamp<\/span>,<\/span>
\nSubstr<\/span>(<\/span>authid<\/span>,<\/span> 1<\/span>,<\/span> 20<\/span>)<\/span>
\nFROM<\/span> sysibm<\/span>.<\/span>sysversions<\/span>
\n<\/span><\/code><\/p>\n`

MySQL<\/strong><\/p>\n

`SELECT<\/span> Version<\/span>(<\/span>)<\/span>;<\/span>
\n<\/span><\/code><\/p>\n`

SQL SERVER<\/strong><\/p>\n

`SELECT<\/span> @@VERSION<\/span>
\n<\/span><\/code><\/p>\n`

Oracle<\/strong><\/p>\n

`SELECT<\/span> *<\/span>
\nFROM<\/span> v$version<\/span>;<\/span><\/span><\/code><\/p>\n`

\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16,25],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nHow to find out datbase version using SQL query<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n