RE: Convert Time?

From: Paul (Paul_at_discussions.microsoft.com)
Date: 02/02/05

Next message: Gabi: "Sending a message from a trigger"
Previous message: David Gugick: "Re: Convert Time?"
In reply to: buc: "Convert Time?"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 2 Feb 2005 12:09:01 -0800

109 should do it... mon dd yyyy hh:mi:ss:mmmAM (or PM)

Check Books Online under CONVERT for details.

Paul

"buc" wrote:

> How can I get the current time in 12H format?
>
> I tried convert(nvarchar,GetDate(),108) changing the 108 to other things but
> I cant seem to find the right one. Changing Regional Options in control
> panel had no affect..
> Thnaks
> BUC
>
>
>

Next message: Gabi: "Sending a message from a trigger"
Previous message: David Gugick: "Re: Convert Time?"
In reply to: buc: "Convert Time?"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Buc2006?
... I don't want to steal anyones thunder, there is a plan for BUC next ... A venue has been found, and people have volunteered to organise ... paul royle ...
(rec.sport.unicycling)
Re: Amandas Fan Club
... I can't wait to hang out with you at BUC and Unicon! ... i cant wait either:D will be great ...
(rec.sport.unicycling)
Re: Convert Time?
... buc wrote: ... > How can I get the current time in 12H format? ... > things but I cant seem to find the right one. ... David Gugick ...
(microsoft.public.sqlserver.programming)