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

's Computer Specifications

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

Thanks Totto

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:e0GaB%(E-Mail Removed)...
> Hi,
> Is it possible to convert date to
> dd mon yyyy hh:mi(24h)
>
> Thanks Totto
>
>

's Computer Specifications

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

"Cowboy (Gregory A. Beamer)" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:e0GaB%(E-Mail Removed)...
>> Hi,
>> Is it possible to convert date to
>> dd mon yyyy hh:mi(24h)
>>
>> Thanks Totto
>>
>>
>
>

's Computer Specifications

"Totto" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

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

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

's Computer Specifications

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

Totto

"Mark Rae" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Totto" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>> Is that with Convert() ? What I want is to drop the seconds
>
> <DateTime variable>.ToString("dd MMM yyyy HH:mm");
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Ops sorry, I'm in the worng group. The question was for SQL Server.
> Transact SQL
>
> Totto
>
>
> "Mark Rae" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> "Totto" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>
>>> Is that with Convert() ? What I want is to drop the seconds
>>
>> <DateTime variable>.ToString("dd MMM yyyy HH:mm");
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert mm/dd/yyyy date format to yyyy-mm-dd	masani paresh	Microsoft Outlook VBA Programming	3	4th Aug 2008 02:38 PM
Need help to convert date from dd/mm/yyyy to mm/dd/yyyy	kiwis	Microsoft Excel Programming	1	25th Apr 2007 11:43 AM
convert date mm/dd/yyyy to dd/mm/yyyy	=?Utf-8?B?bWFyeWo=?=	Microsoft Excel Worksheet Functions	2	20th Mar 2007 07:38 PM
convert date format from mm/dd/yyyy to dd/mm/yyyy	=?Utf-8?B?RXZhbmdlbG9zIERhZmxvcw==?=	Microsoft Access Queries	3	6th Jul 2006 02:30 AM
Convert Date from yyyy/mm/dd to mm/dd/yyyy	=?Utf-8?B?UGVycnk=?=	Microsoft Access	6	25th May 2005 12:07 AM