Click here to Skip to main content
13,193,770 members (39,289 online)
   

Database

 
AnswerRe: Line line is a select statement. Pin
Niju126-Sep-12 22:28
memberNiju126-Sep-12 22:28 
AnswerRe: Line line is a select statement. Pin
ihoecken26-Sep-12 23:04
memberihoecken26-Sep-12 23:04 
QuestionAttendance and leave of employees Pin
Amr Muhammed25-Sep-12 13:06
memberAmr Muhammed25-Sep-12 13:06 
AnswerRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 20:50
memberihoecken25-Sep-12 20:50 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:03
memberAndrei Straut25-Sep-12 21:03 
GeneralRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 21:19
memberihoecken25-Sep-12 21:19 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:20
memberAndrei Straut25-Sep-12 21:20 
QuestionConvert datetime to certain format Pin
vanikanc25-Sep-12 9:09
membervanikanc25-Sep-12 9: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 Pin
ihoecken25-Sep-12 20:58
memberihoecken25-Sep-12 20:58 
QuestionSql server topics and materials Pin
Azizullahazizi24-Sep-12 18:32
memberAzizullahazizi24-Sep-12 18:32 
AnswerRe: Sql server topics and materials Pin
Andrei Straut24-Sep-12 20:12
memberAndrei Straut24-Sep-12 20:12 
AnswerRe: Sql server topics and materials Pin
Sandeep Mewara24-Sep-12 20:23
mvpSandeep Mewara24-Sep-12 20:23 
QuestionSQL Search within a table Pin
veon cheng24-Sep-12 9:31
memberveon cheng24-Sep-12 9:31 
AnswerRe: SQL Search within a table Pin
djj5525-Sep-12 1:08
memberdjj5525-Sep-12 1:08 
GeneralRe: SQL Search within a table Pin
veon cheng25-Sep-12 3:37
memberveon cheng25-Sep-12 3:37 
AnswerRe: SQL Search within a table Pin
ihoecken25-Sep-12 4:13
memberihoecken25-Sep-12 4:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd22-Sep-12 22:38
memberr_mohd22-Sep-12 22:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
Eddy Vluggen23-Sep-12 2:38
memberEddy Vluggen23-Sep-12 2:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell23-Sep-12 8:10
memberjschell23-Sep-12 8:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd24-Sep-12 2:28
memberr_mohd24-Sep-12 2:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell24-Sep-12 12:37
memberjschell24-Sep-12 12:37 
QuestionDb over internet Pin
leone22-Sep-12 8:56
memberleone22-Sep-12 8:56 
AnswerRe: Db over internet Pin
Eddy Vluggen23-Sep-12 0:42
memberEddy Vluggen23-Sep-12 0:42 
AnswerRe: Db over internet Pin
jschell23-Sep-12 8:16
memberjschell23-Sep-12 8:16 
GeneralRe: Db over internet Pin
leone24-Sep-12 0:45
memberleone24-Sep-12 0:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web04 | 2.8.171018.2 | Last Updated 19 Oct 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid