52
1
using System;
2
using System.Globalization;
3
4
public class Program
5
{
6
public static void Main()
7
{
8
var datetime1 = new DateTime(2012, 2, 29);
9
Console.WriteLine(datetime1);
10
11
var datetime2 = datetime1.ToFullTaiwanDate();
12
Console.WriteLine(datetime2);
13
14
var datetime3 = datetime1.ToSimpleTaiwanDate();
15
Console.WriteLine(datetime3);
16
}
17
}
18
19
public static class DateTimeExtensions
20
{
21
/// <summary>
22
/// To the full taiwan date.
23
/// </summary>
24
/// <param name="datetime">The datetime.</param>
Cached Result
原始資料
==============================
-- 連接 TestDB 資料庫
USE TestDB;
GO
/*
多行註解-1
多行註解-2
多行註解-3
多行註解-4
*/
-- Drop Table
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
-- Create Table
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================
處理結果
==============================
USE TestDB;
GO
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================
==============================
-- 連接 TestDB 資料庫
USE TestDB;
GO
/*
多行註解-1
多行註解-2
多行註解-3
多行註解-4
*/
-- Drop Table
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
-- Create Table
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================
處理結果
==============================
USE TestDB;
GO
IF ( EXISTS ( SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'Test' ) )
BEGIN
TRUNCATE TABLE Test;
DROP TABLE Test;
END;
GO
CREATE TABLE Test
(
Id INT PRIMARY KEY
IDENTITY(1, 1)
NOT NULL ,
[Name] NVARCHAR(100) NULL
);
GO
==============================