MySQL function equivalent

Hot Topic

Writing data from multiple tables to a single flat file
Changing the ConnectionString property for a File Connection Manager
Server Man Studio Express Connect error on server but works locally . help??
Trigger problem in SQL 2005
ODBC connection for client application to SQL Server 2005 Express installed on network computer
Start time of a overrunning job
Aggregate function is missing when scripting database objects (SQL2005)
i created a login in SQL SERVER 2005 EXPRESS, but cant login...
Native Client connection to MSSQL 2000
search char in String

SQL Server

import data
SSIS package doesn't execute as a job step
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
Query:Source from multiple tables to a Fact table
2005 Query help
SSIS Diagramming
Prompt for user input in criteria field of view
synchronized backup
Custom role to allow creation and editing of SSIS packages but not scheduling.
Slow Connection Problem

MySQL function equivalent

Hi,

In MySQL, from_unixtime(lonvalue) returns the date format in 'YYYY-MM-DD HH:MM:SS'. Is there any equivalent available in SQL Server, to view the date in man readable format, when the input is an long value in milliseconds.

Eg :

SELECT FROM_UNIXTIME(875996580);

Thanks,
Smitha


Answer this question

MySQL function equivalent

  • Erland Sommarskog

    Take a look at the CONVERT function in Books Online. It has different styles that you can use. Optionally you can format the string using various datepart calls.

    select CONVERT(varchar, CURRENT_TIMESTAMP, 121) -- odbc canonical format

  • Daljinder

    select CONVERT(varchar, '875996580', 121);

    Output :  875996580 


    As I had said earlier, the input is a long value (in milliseconds)




  • HaLaBi

    There is no native function that will understand the Unix format directly. You have to write your own TSQL UDF to do the conversion based on the format.

  • Roberto Kramer

    isnt 'from_unixtime(longvalue)' return a date that is longvalue seconds from 1/1/1970 not milleseconds

    select dateadd(s, 875996580, '1/1/1970')
    yields:
    1997-10-04 20:23:00.000



  • MySQL function equivalent
Answer this question