asked on Date format
Change format f the date
This gives me an American format date is it possible to have date like DD-MM-YYYY
Cheers
create table #table1 (coldate date)
insert #table1 values ('19000101'),('19000202'),(getdate())
declare @sql varchar(2000)
set @sql = 'select iif(coldate < ''19000102'','''',convert(char(10), coldate, 101)) coldate from #table1'
exec (@sql)
This gives me an American format date is it possible to have date like DD-MM-YYYY
Cheers
Microsoft SQL Server
Last Comment
Mark Wills
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks mate, worked like a charm!
I know it has been answered, just posting for completion....
Yes, STYLE code : https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql#date-and-time-styles
Note that 103 gives you slashes whereas 105 gives you hyphens
And most flexible is the format function : https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql
Heres an example
Yes, STYLE code : https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql#date-and-time-styles
Note that 103 gives you slashes whereas 105 gives you hyphens
And most flexible is the format function : https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql
Heres an example
declare @coldate date = getdate()
select format(@coldate,'dd-MM-yyyy')
select format(@coldate,'d','en-gb')
select convert(char(10), @coldate, 105)
select convert(char(10), @coldate, 103)
Will try and brb