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 › sqlservertutorial › 9383SQL DATENAME Function Use and Examples - SQL Server Tips

    5 mar 2020 · It can be a year (yy, yyyy), quarter (qq, q), month (mm, m), dayofyear (dy, y), day (dd, d), week (wk, ww), weekday (dw, w), hour (hh), minute (mi, n), second (ss, s), millisecond (ms), microsecond (mcs), nanosecond (ns), TZoffset (tz), ISO_WEEK (ISOWK,ISOWW). You can use the full name or the abbreviations in parenthesis.

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

    30 gru 2022 · This function returns a character string representing the specified datepart of the specified date. See Date and Time Data Types and Functions (Transact-SQL) for an overview of all Transact-SQL date and time data types and functions. Transact-SQL syntax conventions. Syntax DATENAME ( datepart , date ) Arguments. datepart

  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. 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.

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

    5 gru 2023 · The DATENAME() function in SQL Server retrieves the specific part of the given date. It extracts part of the date, such as the day, month, year, weekday, or quarter of that date. It is helpful when you need to categorize or filter data based on a specified date part and in data analysis or reporting.

  7. sqlskull.com › 2019/12/15 › sql-datenameSQL DATENAME() - SQL Skull

    15 gru 2019 · The DATENAME() function returns a string, navarchar type, that represents a specified date part of date, it can be a day, month, year or time of specific date. DATENAME() is similar to the DATEPART() except for the return type.