Click here to Skip to main content
       

Database

 
AnswerRe: Line line is a select statement. PinmemberNiju126-Sep-12 23:28 
AnswerRe: Line line is a select statement. Pinmemberihoecken27-Sep-12 0:04 
QuestionAttendance and leave of employees PinmemberAmr Muhammed25-Sep-12 14:06 
AnswerRe: Attendance and leave of employees [modified] Pinmemberihoecken25-Sep-12 21:50 
GeneralRe: Attendance and leave of employees [modified] PinmemberAndrei Straut25-Sep-12 22:03 
GeneralRe: Attendance and leave of employees Pinmemberihoecken25-Sep-12 22:19 
GeneralRe: Attendance and leave of employees PinmemberAndrei Straut25-Sep-12 22:20 
QuestionConvert datetime to certain format Pinmembervanikanc25-Sep-12 10:09 
Hello All,
 
I need to convert this value of datetime
2012-09-16T20:08:30Z to this format "mmddyy".
 
I tried
select convert(char(10),'2012-09-16T20:08:30Z',101) - but this did not work.
 
Is there any other method to try before trying to write a whole bunch of casts, replaces!
AnswerRe: Convert datetime to certain format Pinmemberihoecken25-Sep-12 21:58 
QuestionSql server topics and materials PinmemberAzizullahazizi24-Sep-12 19:32 
AnswerRe: Sql server topics and materials PinmemberAndrei Straut24-Sep-12 21:12 
AnswerRe: Sql server topics and materials PinmvpSandeep Mewara24-Sep-12 21:23 
QuestionSQL Search within a table Pinmemberveon cheng24-Sep-12 10:31 
AnswerRe: SQL Search within a table Pinmemberdjj5525-Sep-12 2:08 
GeneralRe: SQL Search within a table Pinmemberveon cheng25-Sep-12 4:37 
AnswerRe: SQL Search within a table Pinmemberihoecken25-Sep-12 5:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd22-Sep-12 23:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE PinmemberEddy Vluggen23-Sep-12 3:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberjschell23-Sep-12 9:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd24-Sep-12 3:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberjschell24-Sep-12 13:37 
QuestionDb over internet Pinmemberleone22-Sep-12 9:56 
AnswerRe: Db over internet PinmemberEddy Vluggen23-Sep-12 1:42 
AnswerRe: Db over internet Pinmemberjschell23-Sep-12 9:16 
GeneralRe: Db over internet Pinmemberleone24-Sep-12 1:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 18 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid