Shulou(Shulou.com)05/31 Report--

This article mainly talks about "what are the differences between SQLServer 2005 and Oracle". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what's the difference between SQLServer 2005 and Oracle?"

1. Get the current time of the system

SQL Server 2005:

Select getdate ()

Oracle:

Select sysdate from dual

two。 Get the year, month and day

SQL Server 2005:

The copy code is as follows:

Select year (getdate ())-2011

Select month (getdate ())-3

Select day (getdate ())-23

Oracle:

The copy code is as follows:

Select to_char (sysdate,'yyyy') from dual-2011

Select to_char (sysdate,'mm') from dual-03

Select to_char (sysdate,'dd') from dual-23

Q quarter

Hh hours (12)

Hh34 hours (24)

Mi score

Ss second

What day is it in D week?

At this point, I believe you have a deeper understanding of "what is the difference between SQLServer 2005 and Oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.