How to convert second into datetime's 108 format hh:mm:ss in sql server without writing function -

  v1. *, Datediff (ss, v1.dateofchange, v2.dateofchange) vActualTime Join V1 left as acutaltime the vicutualtime v1 v2.rowno = v2.rowno-1 FK_PatientId FK_Status_PatientId Tithif Change rowno acutaltime -------- ---- ------------------- -------------------------- ---------------- -------- --- 3 16 2010-08-02 15: 43: 46,000 1 757 3 24 2010-08-02 15: 56: 23.000 2 96 3 26 2010-08-02 15: 57: 59.000 3 umbilical  

I am using SQL server 2005 am

when I write I

  select v1 *, Datediff (mi, v1.dateofchange, v2.dateofchange) Vitaittaim V1 from [date] as joining vActualTime v2 on v1.rowno = v2 as Attyutataim, (datetime, datediff (mi, v1.dateofchange, v2 .dateofchange), 108).  

I get it

  FK_PatientId FK_Status_PatientId DateofChange off Sittaim Date ------------ ------- ------------ ---------- ------------- --------------- ----- ---------- - ------ ----------------- 3 16 2010-08-02 15:43: 46.000 1 13 19 00-01-14 00: 00: 00.000 3 24 2010-08-02 15: 56: 23.000 2 1 9 00-01-02 00: 00: 00.000 3 26 2010-08-02 15: 57: 59.000 3 Tap faucet  

It should have been given as 00-00 -00 00: 13: 00: 0000

I think you need to take your calculation minutes (you are dated) and display that 108 in a time format.

This minute is a datetime format of 108, i.e. hh: mm: ss

  convert (negotiation, dateaid (min, dated (mi, v1.dat) Select Eofchange , V2.dateofchange), '00: 00: 00 '), 108)  

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....

Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...

Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...

Read more

Powered by Blogger

Theme images by Michael Elkan

Unknown

Visit profile

Archive

• September 2015774
• August 2015784
• July 2015788
• June 2015730
• May 2015758
• April 2015711
• March 2015752
• February 2015779
• January 2015734
• September 2014763

• August 2014763
• July 2014732
• June 2014769
• May 2014679
• April 2014792
• March 2014763
• February 2014752
• January 2014705
• September 2013736
• August 2013746
• July 2013785
• June 2013735
• May 2013721
• April 2013739
• March 2013762
• February 2013793
• January 2013801
• September 2012798
• August 2012800
• July 2012737
• June 2012725
• May 2012723
• April 2012766
• March 2012712
• February 2012772
• January 2012836
• September 2011705
• August 2011730
• July 2011728
• June 2011746
• May 2011785
• April 2011772
• March 2011728
• February 2011747
• January 2011769
• September 2010745
• August 2010808
• July 2010731
• June 2010770
• May 2010760
• April 2010771
• March 2010800
• February 2010741
• January 2010807

Show more Show less

Report Abuse