<div>
Can you explain what UNIX_TIMESTAMP() does in MySQL?<br />
IN MSSQL there is the timestamp datatype, read about it, maybe is what you need.<br />
gl
</div>


Can you explain what UNIX_TIMESTAMP() does in MySQL?
IN MSSQL there is the timestamp datatype, read about it, maybe is what you need.
gl

<div>
ok, i tried your string, Eugene, which works fine. but how can i put in a column content? i tried this:<br />
<br />
&quot;select taskID, userID, datediff(ss,'1970-01-01 02:00:00.000','taskDate') from tblTasks;&quot;<br />
<br />
but it doesn't work. do you know why? thanks for hints!<br />
<br />
<br />
regards,<br />
christoph
</div>


ok, i tried your string, Eugene, which works fine. but how can i put in a column content? i tried this:

"select taskID, userID, datediff(ss,'1970-01-01 02:00:00.000','taskDate') from tblTasks;"

but it doesn't work. do you know why? thanks for hints!


regards,
christoph

<div>
select taskID, userID, datediff(ss,'1970-01-01 02:00:00.000',taskDate) from tblTasks;&quot;
</div>


select taskID, userID, datediff(ss,'1970-01-01 02:00:00.000',taskDate) from tblTasks;"

<div>
<div class="content wysiwyg-content">
hello!<br />
<br />
I am looking for a way, to transform the date format in the database into a unix timestamp while querying. In the database, the format is DD.MM.YY and I am looking for a function similar to &quot;UNIX_TIMESTAMP()&quot; in MySQL in MS SQL. Is there something like that?<br />
<br />
Thanks for any help!<br />
<br />
regards,<br />
Christoph
</div>
</div>


hello!

I am looking for a way, to transform the date format in the database into a unix timestamp while querying. In the database, the format is DD.MM.YY and I am looking for a function similar to "UNIX_TIMESTAMP()" in MySQL in MS SQL. Is there something like that?

Thanks for any help!

regards,
Christoph

ms sql query string syntax for formatting date functions?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.