Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 23289218sql - How to convert Epoch time to date? - Stack Overflow

    That is EPOCH time: number of seconds since Epoch(1970-01-01). Use this: SELECT CAST(DATE '1970-01-01' + ( 1 / 24 / 60 / 60 ) * '1310112003' AS TIMESTAMP) FROM DUAL;

  2. www.databasestar.com › convert-datetime-to-dateHow to Convert DATETIME to DATE in SQL Server - Database Star

    31 maj 2023 · SQL Convert Datetime to Date. You can convert a DATETIME to a DATE using the CONVERT function. The syntax for this is CONVERT (datetime, format). For example, to convert the current date and time into just a date: SELECT CONVERT(date, GETDATE()); Result: 2022-09-02. This shows the date only and no time. What other methods exist?

  3. www.sqlservertutorial.net › sql-server-system-functions › convert-datetime-to-dateConvert Datetime to Date in SQL Server By Practical Examples

    Convert datetime to date using the CAST() function. The following statement converts a datetime value to a date using the CAST() function: CAST(datetime_expression AS DATE) Code language: SQL (Structured Query Language) (sql) This example uses the CAST() function to convert the current datetime to a date value: SELECT CAST (GETDATE AS DATE ...

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

    13 lis 2023 · Determine SQL Server Date and Time Parts with DATEPART and DATENAME Functions. Working with Date and Time Data Types in SQL Server. Query SQL Server Data Based on Various Date and Time Functions. SQL Date Calculation Simplifications in SQL Server. SQL Server function to convert integer date to datetime format. Daylight Savings Time Functions in ...

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

    8 mar 2019 · SQL Server High Precision Date and Time Functions have a scale of 7 and are: SYSDATETIME – returns the date and time of the machine the SQL Server is running on. SYSDATETIMEOFFSET – returns the date and time of the machine the SQL Server is running on plus the offset from UTC.

  6. database.guide › examples-of-converting-time-to-datetime-in-sql-server-t-sqlExamples of Converting ‘time’ to ‘datetime’ in SQL Server (T-SQL)

    This article contains examples of converting a time value to a datetime value in SQL Server. When you convert a time value to datetime, extra information is added to the value. This is because the datetime data type contains both date and time information.

  7. www.epochconverter.comEpoch Converter - Unix Timestamp Converter

    1 sty 2001 · Easy epoch/Unix timestamp converter for computer programmers. Includes epoch explanation and conversion syntax in various programming languages.