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]

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

 

[Mark Rae]

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

 

[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!
*************************************************