Something to remember :)

MikeO'Mighty · **Joined:** Wed Dec 19, 2007 12:02 pm **Posts:** 5

T-sql mm-dd-yy HH:MM formatting
select CONVERT(CHAR(9),GETDATE(),10)+RIGHT(CONVERT(CHAR(19),GETDATE(),100),7)

T-sql mm/dd/yy HH:MM formatting
select CONVERT(CHAR(9),GETDATE(),1)+RIGHT(CONVERT(CHAR(19),GETDATE(),100),7)

T-sql full address
select (Street1+(case len(Street2) when 0 then '' else ','+Street2 end)+', '+City+', '+State+' '+Zip) as Address

All things Ticketing

Forum rules

Something to remember :)

Who is online