Update list of time values from single column in SQL Server?
Apqu
This is very hard to explain but basically I have a list of time values as follows in VARCHAR format:
I need to convert these so that each becomes the difference between 12:00:00 and the value in the field using just an UPDATE command?
How would you approach this situation in TSQL? Being as it is a VARCHAR and we have no date part I guess we cannot use any date functions?
Anon
Use the CONVERT(datetime,@varchar,14) function to change between varchar and datetime without concern for the date portion.
SELECT CONVERT(varchar(8), CONVERT(datetime,'12:00:00',14)-CONVERT(datetime,'9:19:4',14) ,14)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Is it possible to pass a function a string to be used to create a global matrix?
- Next: MySQL select statment when comparing two columns
Related
Related Related
- 1
Sql update column with time from
- 2
How to swap the column bit values in a table with a single update query in SQL Server
- 3
SQL Server 2000 - Returning a single column value from a 4 column table based on the values of the other 3 columns
- 4
Automatically update column values in SQL Server
- 5
Automatically update column values in SQL Server
- 6
sql server multiple column values in single column by building query
- 7
Insert values from a list in a single SQL statement
- 8
SQL Server Generate a specific set of year values from a column which gives me one single date/year
- 9
SQL Server Generate a specific set of year values from a column which gives me one single date/year
- 10
Update a column from multiple columns in SQL Server
- 11
from existing value Update column using comma-separated values in SQL Server
- 12
from existing value Update column using comma-separated values in SQL Server
- 13
Update Single XML Node Value of XML Column using SQL Server
- 14
Update Single XML Node Value of XML Column using SQL Server
- 15
Pivot and concatenate values from column in SQL Server
- 16
select values from specific column in sql server?
- 17
SQL - get list of different values from column
- 18
SQL - get list of different values from column
- 19
SQL - Update a single column from the max value of multiple tables
- 20
Query function in Java, return a list of all values from single column
- 21
SQL Server: update column with only numbers from another column
- 22
Wrong column values SQL Server Views after table schema update
- 23
sql server update where column in (duplicate values) - how many updates?
- 24
SQL Server : List all values from tableA for each values in tableB
- 25
SQL Server query for getting single value from each column into a single column
- 26
SQL Server - Update column from data in the same table
- 27
update a column of table in sql server from ms access
- 28
Update a column with records from current row in SQL Server
- 29
update time only in sql server
Comments