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. stackoverflow.com › questions › 4492568sql - How to display a day from the Date - Stack Overflow

    12 lis 2016 · As @Lamak suggested, you can use the DATENAME function if you're on SQL Server 2005 or later: SELECT DATENAME(dw, DateField) FROM Table On earlier versions, the closest you could get was the DATEPART function with dw as the interval, but you needed a CASE to convert the number returned to the day name, as seen here .

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

    5 mar 2020 · SELECT DATENAME(YY, BirthDate) as year, DATENAME(MM, BirthDate) as month, DATENAME(dd, BirthDate) as day FROM HumanResources.Employee DATENAME Example with Different Units The following example shows the datename using different units.

  5. www.mssqltips.com › sqlservertip › 1145Date and Time Conversions Using SQL Server

    13 lis 2023 · SQL Server provides a number of options you can use for formatting a date/time string in SQL queries and stored procedures either from an input file (Excel, CSV, etc.) or a date column (datetime, datetime2, smalldatetime, etc.) from a table.

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

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