<div>
How about seconds from date 0 (1900-01-01) ?<br />
<br />
convert(bigint, convert(float, datetimesubmitted)*24*60*6<wbr />0)
</div>


How about seconds from date 0 (1900-01-01) ?

convert(bigint, convert(float, datetimesubmitted)*24*60*60)

<div>
Or the Unix timestamp, which is number of seconds from 1970-01-01 12:00am<br />
<br />
convert(int, (convert(float, datetimesubmitted)-convert<wbr />(float, convert(datetime,'19700101<wbr />')))*24*60<wbr />*60)
</div>


Or the Unix timestamp, which is number of seconds from 1970-01-01 12:00am

convert(int, (convert(float, datetimesubmitted)-convert(float, convert(datetime,'19700101')))*24*60*60)

<div>
Hi VjSoft<br />
Thanks - I was one bracket away from the right solution and then chucked it out <br />
Alan
</div>


Hi VjSoft
Thanks - I was one bracket away from the right solution and then chucked it out
Alan

<div>
<div class="content wysiwyg-content">
Hi Gurus<br />
<br />
I am pulling my hair out. &nbsp;How do i return an integer that is unique based on date AND time from a date time field. &nbsp;The value currently in the datetime field which is called datetimsubmitted is '2010/09/03 10:18:05 AM'<br />
<br />
It is easy to return an integer from the date only but each record needs to be uniquely identified by an integer based on date and time to the second<br />
many thanks <br />
Alan
</div>
</div>


Hi Gurus

I am pulling my hair out.  How do i return an integer that is unique based on date AND time from a date time field.  The value currently in the datetime field which is called datetimsubmitted is '2010/09/03 10:18:05 AM'

It is easy to return an integer from the date only but each record needs to be uniquely identified by an integer based on date and time to the second
many thanks 
Alan

How do Return a unique number from a datetime field in sql 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.