Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. www.w3schools.com › sql › func_sqlserver_datenameSQL Server DATENAME() Function - W3Schools

    25 sie 2017 · The DATENAME() function returns a specified part of a date. This function returns the result as a string value. Syntax

  2. www.mssqltips.com › sqlservertip › 5993SQL Server Date and Time Functions with Examples

    17 maj 2021 · Learn SQL Server date and time functions SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, CURRENT_TIMESTAMP, GETDATE (), DATENAME, DATEPART with examples.

  3. www.mssqltips.com › sqlservertutorial › 9383SQL DATENAME Function Use and Examples - SQL Server Tips

    5 mar 2020 · DATENAME with a Table Data The following example shows the year, month and day of birthdates of the employee table. SELECT DATENAME(YY, BirthDate) as year, DATENAME(MM, BirthDate) as month, DATENAME(dd, BirthDate) as day FROM HumanResources.Employee

  4. www.sqlservertutorial.net › sql-server-date-functions › sql-server-datename-functionSQL Server DATENAME() Function - SQL Server Tutorial

    Learn how to use the SQL Server DATENAME() function to get a character string that represents a specified date part of a date.

  5. learn.microsoft.com › en-us › sqlDATENAME (Transact-SQL) - SQL Server | Microsoft Learn

    30 gru 2022 · SELECT DATENAME(year, '12:10:30.123') ,DATENAME(month, '12:10:30.123') ,DATENAME(day, '12:10:30.123') ,DATENAME(dayofyear, '12:10:30.123') ,DATENAME(weekday, '12:10:30.123'); If date is specified as a variable or table column, and the data type for that variable or column does not have the specified datepart , DATENAME will return error 9810.

  6. sqlserverguides.com › datename-function-of-sql-serverDATENAME Function of SQL Server

    5 gru 2023 · In this SQL Server tutorial, you will learn about the DATENAME function in SQL Server. You will understand the syntax of the DATENAME() and extract the different date parts. Also, you will learn how to use the DATENAME() column with the table.

  7. learnsql.com › blog › performing-calculations-date-time-related-valuesPerforming Calculations on Date- and Time-Related Values

    24 sty 2017 · We'll use the following SQL code snippet to create an example table: CREATE TABLE emergency_dispatch ( emergency_id integer, phone_pickup timestamp, first_keystroke timestamp, unit_assigned timestamp, unit_assigned_id integer, unit_on_road timestamp, unit_arrived timestamp, help_finished timestamp