SQL Server 2008中的创建格式化日期(1)-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

SQL Server 2008中的创建格式化日期(1)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:09 PM

server sql create I date format

让我们来创建dbo.format_date 函数，如下所示。 /******Object:UserDefinedFunction[dbo].[format_date] Script Date :05/12/200923:19:35******/ IFEXISTS( SELECT * FROM sys.objects WHERE object_id=OBJECT_ID(N '[dbo].[format_date]' ) AND type in (N

让我们来创建dbo.format_date 函数，如下所示。

<ol class="dp-sql">
<li class="alt"><span><span>/****** Object: UserDefinedFunction [dbo].[format_date]   </span></span></li>
<li>
<span>Script </span><span class="keyword">Date</span><span>: 05/12/2009 23:19:35 ******/  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span>IF EXISTS (</span><span class="keyword">SELECT</span><span> * </span><span class="keyword">FROM</span><span> sys.objects  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">WHERE</span><span> object_id = OBJECT_ID(N</span><span class="string">'[dbo].[format_date]'</span><span>)  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="op">AND</span><span> type </span><span class="op">in</span><span> (N</span><span class="string">'FN'</span><span>, N</span><span class="string">'IF'</span><span>, N</span><span class="string">'TF'</span><span>, N</span><span class="string">'FS'</span><span>, N</span><span class="string">'FT'</span><span>))  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">DROP</span><span> </span><span class="keyword">FUNCTION</span><span> [dbo].[format_date]  </span>
</li>
<li class="alt"><span> </span></li>
<li><span>GO  </span></li>
<li class="alt"><span> </span></li>
<li><span>/****** Object: UserDefinedFunction [dbo].[format_date]  </span></li>
<li class="alt"><span> </span></li>
<li>
<span>Script </span><span class="keyword">Date</span><span>: 05/12/2009 23:19:18 ******/  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">SET</span><span> ANSI_NULLS </span><span class="keyword">ON</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li><span>GO  </span></li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">SET</span><span> QUOTED_IDENTIFIER </span><span class="keyword">ON</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li><span>GO  </span></li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">SET</span><span> CONCAT_NULL_YIELDS_NULL </span><span class="keyword">OFF</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li><span>go  </span></li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">CREATE</span><span> </span><span class="keyword">function</span><span> [dbo].[format_date]  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span>(@inputdate datetime ,@format </span><span class="keyword">varchar</span><span>(500))  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">returns</span><span> </span><span class="keyword">varchar</span><span>(500)  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">as</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">begin</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @</span><span class="func">year</span><span> </span><span class="keyword">varchar</span><span>(4) </span><span class="comment">--YYYY </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @shortyear </span><span class="keyword">varchar</span><span>(4) </span><span class="comment">--Yr </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @quarter </span><span class="keyword">varchar</span><span>(4) </span><span class="comment">--QQ </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @</span><span class="func">month</span><span> </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--MM </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @week </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--WW </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @</span><span class="func">day</span><span> </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--DD </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @24hours </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--24HH </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @12hours </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--HH </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @minutes </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--MI </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @seconds </span><span class="keyword">varchar</span><span>(2) </span><span class="comment">--SS </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @milliseconds </span><span class="keyword">varchar</span><span>(3) </span><span class="comment">--MS </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @microseconds </span><span class="keyword">varchar</span><span>(6) </span><span class="comment">--MCS </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @nanoseconds </span><span class="keyword">varchar</span><span>(9) </span><span class="comment">--NS </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @dayname </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--DAY </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @monthname </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--MONTH </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @shortmonthname </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--MON </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @AMPM </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--AMPM </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @TZ </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--TZ </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @UNIXPOSIX </span><span class="keyword">varchar</span><span>(15) </span><span class="comment">--UNIXPOSIX </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="comment">--UCASE </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="comment">--LCASE </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">declare</span><span> @formatteddate </span><span class="keyword">varchar</span><span>(500)  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="comment">--Assign current date and time to </span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span>if (@inputdate </span><span class="keyword">is</span><span> </span><span class="op">NULL</span><span> </span><span class="op">or</span><span> @inputdate =</span><span class="string">''</span><span>)  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">begin</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">set</span><span> @inputdate = getdate()  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">end</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span>if (@format </span><span class="keyword">is</span><span> </span><span class="op">NULL</span><span> </span><span class="op">or</span><span> @format =</span><span class="string">''</span><span>)  </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">begin</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">set</span><span> @format =</span><span class="string">'YYYY-MM-DD 12HH:MI:SS AMPM'</span><span> </span>
</li>
<li class="alt"><span> </span></li>
<li>
<span class="keyword">end</span><span> </span>
</li>
</ol>

Copy after login

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Best Graphic Settings

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

2 weeks ago By DDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Chat Commands and How to Use Them

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Where is the login entrance for gmail email?

7518

CakePHP Tutorial

1378

What is the format of the account name of steam

win11 activation key permanent

nyt connections hints and answers

Related knowledge

How to search previous Weibo by date on Weibo_How to search previous Weibo by date on Weibo Mar 30, 2024 pm 07:26 PM

1. First open the mobile web browser, search for the Weibo web version, and click the avatar button in the upper left corner after entering. 2. Then click Settings in the upper right corner. 3. Click the version switching option in settings. 4. Then select the color version option in the version switch. 5. Click Search to enter the search page. 6. After entering the keywords, click Find People. 7. When the search completion interface appears, click Filter. 8. Finally, enter the specific date in the release time column and click Filter.

What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

Usage of division operation in Oracle SQL Mar 10, 2024 pm 03:06 PM

"Usage of Division Operation in OracleSQL" In OracleSQL, division operation is one of the common mathematical operations. During data query and processing, division operations can help us calculate the ratio between fields or derive the logical relationship between specific values. This article will introduce the usage of division operation in OracleSQL and provide specific code examples. 1. Two ways of division operations in OracleSQL In OracleSQL, division operations can be performed in two different ways.

Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

How to remove the date that appears automatically when printing from PPT handouts Mar 26, 2024 pm 08:16 PM

1. Let me first talk about the method I used at the beginning, maybe everyone is using it too. First, open [View]——]Remarks Template[. 2. A place where you can actually see the date after opening it. 3. Select it first and delete it. 4. After deleting, click [Close Master View]. 5. Open the print preview again and find that the date is still there. 6. In fact, this date was not deleted here. It should be in the [Handout Master]. Look at the picture below. 7. Delete the date after you find it. 8. Now when you open the preview and take a look, the date is no longer there. Note: In fact, this method is also very easy to remember, because the printed handouts are handouts, so you should look for the [Handout Master].

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Feb 26, 2024 pm 07:48 PM

Interpretation of MyBatis dynamic SQL tags: Detailed explanation of Set tag usage MyBatis is an excellent persistence layer framework. It provides a wealth of dynamic SQL tags and can flexibly construct database operation statements. Among them, the Set tag is used to generate the SET clause in the UPDATE statement, which is very commonly used in update operations. This article will explain in detail the usage of the Set tag in MyBatis and demonstrate its functionality through specific code examples. What is Set tag Set tag is used in MyBati

How to create a folder on Realme Phone? Mar 23, 2024 pm 02:30 PM

Title: Realme Phone Beginner’s Guide: How to Create Folders on Realme Phone? In today's society, mobile phones have become an indispensable tool in people's lives. As a popular smartphone brand, Realme Phone is loved by users for its simple and practical operating system. In the process of using Realme phones, many people may encounter situations where they need to organize files and applications on their phones, and creating folders is an effective way. This article will introduce how to create folders on Realme phones to help users better manage their phone content. No.

How to install, uninstall, and reset Windows server backup Mar 06, 2024 am 10:37 AM

WindowsServerBackup is a function that comes with the WindowsServer operating system, designed to help users protect important data and system configurations, and provide complete backup and recovery solutions for small, medium and enterprise-level enterprises. Only users running Server2022 and higher can use this feature. In this article, we will explain how to install, uninstall or reset WindowsServerBackup. How to Reset Windows Server Backup If you are experiencing problems with your server backup, the backup is taking too long, or you are unable to access stored files, then you may consider resetting your Windows Server backup settings. To reset Windows

See all articles