Need specific DateTime format

[Delphard]

How to format DateTime value like this:
'29.01.2008. 23:56'

Thanks in advance!

 

[HarleyQuinn]

I'd have a look at CONVERT()

Hope this helps.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[AlexCuse]

To the best of my (limited) knowledge, you can't get the dots with CONVERT(), so you'd need to use replace as well.

But more importantly, are you trying to do this in T-SQL or VBScript?

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[HarleyQuinn]

Alex,

Could you do the dots using something like

SELECT (CONVERT(VARCHAR(10), GETDATE(), 104)) + '. ' + (CONVERT(VARCHAR(5), GETDATE(), 8))

I've not got SQLServer to test this on though (just been looking at BOL) so if that's way off I'm sorry



HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[AlexCuse]

Yeah, that works. I was hoping there was a format you could use REPLACE() on to get everything in one shot, but there seems to be a problem with the 131 format (it gives me some screwy date in 1429 !)

Of course if it has to be done in VBScript it was all for nothing

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[HarleyQuinn]

problem with the 131 format (it gives me some screwy date in 1429 !)

Oh er!

Got to agree though, if it's VBS then it's time wasted

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[AlexCuse]

A friend passed this along. Apparently 130 and 131 are reserved for a special Calendar:

http://blogs.msdn.com/wael/archive/2007/04/29/sql-server-hijri-hijra-dates.aspx

And my money is on it being a T-SQL problem, but who knows? Besides, its' never time wasted


[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[HarleyQuinn]

Besides, its' never time wasted

Well, I got to do this instead of work for a bit

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Delphard]

HarleyQuinn, your solution is perfect!
CODE
SELECT (CONVERT(VARCHAR(10), GETDATE(), 104)) + '. ' + (CONVERT(VARCHAR(5), GETDATE(), 8))

Thanks!

 

[HarleyQuinn]

You're welcome, glad I could help

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[AlexCuse]

Me thinks its worth a little recognition

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[HarleyQuinn]

Cheers Alex

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.