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**********@l osmail.nowrote in message
news:e0******** ********@TK2MSF TNGP05.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.netNoS pamMwrote in
message news:%2******** ********@TK2MSF TNGP06.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**********@l osmail.nowrote in message
news:e0******** ********@TK2MSF TNGP05.phx.gbl. ..

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

Thanks Totto

[Mark Rae]

"Totto" <to**********@l osmail.nowrote in message
news:Op******** ******@TK2MSFTN GP06.phx.gbl...

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

<DateTime variable>.ToStr ing("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**@markNOSPA Mrae.comwrote in message
news:e5******** ******@TK2MSFTN GP04.phx.gbl...

"Totto" <to**********@l osmail.nowrote in message
news:Op******** ******@TK2MSFTN GP06.phx.gbl...

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

<DateTime variable>.ToStr ing("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**********@l osmail.nowrote in message
news:%2******** *******@TK2MSFT NGP02.phx.gbl.. .

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

Totto
"Mark Rae" <ma**@markNOSPA Mrae.comwrote in message
news:e5******** ******@TK2MSFTN GP04.phx.gbl...

>"Totto" <to**********@l osmail.nowrote in message
news:Op******* *******@TK2MSFT NGP06.phx.gbl.. .

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

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