SQL Server/T-SQL/Date Timezone/Datetime

Материал из SQL эксперт
Перейти к: навигация, поиск

Converted to a datetime

   <source lang="sql">

1> create table employee( 2> ID int, 3> name nvarchar (10), 4> salary int, 5> start_date datetime, 6> city nvarchar (10), 7> region char (1)) 8> GO 1> 2> 3> -- Converted to a datetime 4> 5> insert into employee (ID, name, salary, start_date, city, region) 6> values (1, "Jason", 40420, "02/01/94", "New York", "W") 7> GO (1 rows affected) 1> insert into employee (ID, name, salary, start_date, city, region) 2> values (2, "Robert",14420, "01/02/95", "Vancouver","N") 3> GO (1 rows affected) 1> 2> select * from employee 3> GO ID name salary start_date city region

---------- ----------- ----------------------- ---------- ------ 
         1 Jason            40420 1994-02-01 00:00:00.000 New York   W
         2 Robert           14420 1995-01-02 00:00:00.000 Vancouver  N

(2 rows affected) 1> 2> 3> 4> 5> drop table employee 6> GO 

      </source>


DATETIME column

   <source lang="sql">

3> CREATE TABLE works_on (emp_no INTEGER NOT NULL, 4> project_no CHAR(4) NOT NULL, 5> job CHAR (15) NULL, 6> enter_date DATETIME NULL) 7> GO 1> 2> drop table works_on; 3> GO 

</source>


Get Day only from a datetime variable

   <source lang="sql">

18> 19> CREATE FUNCTION DayOnly(@Date datetime) 20> RETURNS varchar(12) 21> WITH SCHEMABINDING 22> AS 23> BEGIN 24> RETURN CONVERT(varchar(12), @Date, 101) 25> END 26> GO 1> select dbo.DayOnly(GetDATE()) 2> GO

10/22/2006 (1 rows affected) 1> drop function DayOnly 2> GO 1> 2> 

      </source>
Источник — «http://sqle.ru/index.php?title=SQL_Server/T-SQL/Date_Timezone/Datetime&oldid=6071»