Convert date to: dd mon yyyy hh:mi(24h)

[Totto]

Hi,
Is it possible to convert date to
dd mon yyyy hh:mi(24h)

Thanks Totto

[Cowboy \(Gregory A. Beamer\)]

Big H, not little h flips from 12h to 24h

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Totto" <to**********@losmail.nowrote in message
news:e0****************@TK2MSFTNGP05.phx.gbl...

Hi,
Is it possible to convert date to
dd mon yyyy hh:mi(24h)

Thanks Totto

[Totto]

Hi Gregory,
Is that with Convert() ? What I want is to drop the seconds
Thanks Totto

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:%2****************@TK2MSFTNGP06.phx.gbl...

Big H, not little h flips from 12h to 24h

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Totto" <to**********@losmail.nowrote in message
news:e0****************@TK2MSFTNGP05.phx.gbl...

>Hi,
Is it possible to convert date to
dd mon yyyy hh:mi(24h)

Thanks Totto

[Mark Rae]

"Totto" <to**********@losmail.nowrote in message
news:Op**************@TK2MSFTNGP06.phx.gbl...

Is that with Convert() ? What I want is to drop the seconds

<DateTime variable>.ToString("dd MMM yyyy HH:mm");

[Totto]

Ops sorry, I'm in the worng group. The question was for SQL Server. Transact
SQL

Totto
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:e5**************@TK2MSFTNGP04.phx.gbl...

"Totto" <to**********@losmail.nowrote in message
news:Op**************@TK2MSFTNGP06.phx.gbl...

>Is that with Convert() ? What I want is to drop the seconds

<DateTime variable>.ToString("dd MMM yyyy HH:mm");

[Cowboy \(Gregory A. Beamer\)]

Transact SQL? http://msdn2.microsoft.com/en-us/library/ms187928.aspx

Also in books Online

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Totto" <to**********@losmail.nowrote in message
news:%2***************@TK2MSFTNGP02.phx.gbl...

Ops sorry, I'm in the worng group. The question was for SQL Server.
Transact SQL

Totto
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:e5**************@TK2MSFTNGP04.phx.gbl...

>"Totto" <to**********@losmail.nowrote in message
news:Op**************@TK2MSFTNGP06.phx.gbl...

>>Is that with Convert() ? What I want is to drop the seconds

<DateTime variable>.ToString("dd MMM yyyy HH:mm");