Yahoo Αναζήτηση Διαδυκτίου

Αποτελέσματα Αναζήτησης

1. stackoverflow.com › questions › 5125609How to select date without time in SQL - Stack Overflow

   stackoverflow.com › questions › 5125609

   26 Φεβ 2011 · It seems to combine the SQL Server T-SQL GetDate() with the Oracle PL/SQL TO_DATE(). If it did work, it appears to involve an unnecessary date/time to text to date conversion, which is unnecessarily inefficient.

2. learnsql.com › cookbook › how-to-get-the-current-date-without-time-in-t-sqlHow to Get the Current Date (Without Time) in T-SQL

   learnsql.com › cookbook › how-to-get-the-current-date-without-time-in-t-sql

   • Αποθηκευμένο αντίγραφο

   Learn how to use the GETDATE() and CAST() functions to get the current date without the time component in SQL Server. See the problem, solution and discussion with examples and screenshots.

3. dba.stackexchange.com › questions › 1426sql server - How to get the current date without the time part...

   dba.stackexchange.com › questions › 1426

   24 Φεβ 2011 · start of month: DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) end of last month: DATEADD(month, DATEDIFF(month, 0, GETDATE()), -1) start of next month: DATEADD(month, DATEDIFF(month, 0, GETDATE()), 31)

4. www.geeksforgeeks.org › how-to-get-the-current-date-without-time-in-t-sqlHow To Get the Current Date Without Time in T-SQL?

   www.geeksforgeeks.org › how-to-get-the-current-date-without-time-in-t-sql

   • Αποθηκευμένο αντίγραφο

   26 Μαΐ 2024 · Syntax to get the current date without time in T-SQL is: SELECT CAST( GETDATE() AS Date ) ; We’ll use the GETDATE() function to get the current date and time.

5. www.baeldung.com › sql › select-date-without-timeHow to Select a Date Without Including the Time in SQL - Baeldung

   www.baeldung.com › sql › select-date-without-time

   • Αποθηκευμένο αντίγραφο

   13 Ιουλ 2024 · Learn different ways to extract only dates from DATETIME values in SQL, such as using the DATE (), CAST (), and DATE_FORMAT () functions. See practical examples using the student table in MySQL.

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

   www.mssqltips.com › sqlservertip › 5993

   • Αποθηκευμένο αντίγραφο

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

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

   learn.microsoft.com › en-us › sql

   • Αποθηκευμένο αντίγραφο

   Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running. SYSDATETIME and SYSUTCDATETIME have more fractional seconds precision than GETDATE and GETUTCDATE.