Search
 
SCRIPT & CODE EXAMPLE
 

SQL

CONVERT time string into 12 hours in sql

declare @t time
set @t = '14:40'

select CONVERT(varchar(15),@t,100)
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle number to percentage 
Sql :: mysql find duplicates in same table 
Sql :: How can I tell how many Cores SQL Server is actually using? 
Sql :: postgres extract day from date 
Sql :: add colum date in sql 
Sql :: how to find the number of rows updated in oracle pl/sql 
Sql :: how to install sql in anaconda 
Sql :: how to inner join 4 tables in sql 
Sql :: mysql select date range last 30 days 
Sql :: creating postgresSQL database using the the shell 
Sql :: mysql json query 
Sql :: adding generated time in row mysql workbench 
Sql :: how to enable mysql 5.7 root user password on linux 
Sql :: avg sql 
Sql :: sql server date format yyyy-MM-ddThh:mm:ss 
Sql :: Get first name and last name from full name string in SQL 
Sql :: create table in mysql mariadb primary key foreign key 
Sql :: mysql delete database 
Sql :: partition by sql server 
Sql :: sql number columns 
Sql :: how to select an index in oracle sql 
Sql :: Index a database column sql 
Sql :: mysql root permission denied lost 
Sql :: oracle view dependencies 
Sql :: sql integer to serial 
Sql :: ms sql database data size 
Sql :: postgre insert select 
Sql :: sql get character at index 
Sql :: 2nd max salary query in sql 
Sql :: sql find all different values in column 
ADD CONTENT
Topic
Content
Source link
Name
9+4 =