Styjun

Wordplay subtraction paradox

Optimising the Selection of MaxValue in Association

How can the electric potential be zero at a point where the electric field isn't, if that field can give a test charge kinetic energy?

Why are there no polls of Tom Steyer yet?

Is it okay for a chapter's POV to shift as it progresses?

Which GPUs to get for Mathematical Optimization (if any...)?

How can I obtain a complete list of the kinds of atomic expressions in the Wolfram Language using only the language itself?

Intel 8080-based home computers

Why is Google approaching my VPS machine?

Is straight-up writing someone's opinions telling?

Does inertia keep a rotating object rotating forever, or something else?

How would you say "Sorry, that was a mistake on my part"?

What is this green alien supposed to be on the American covers?

What "fuel more powerful than anything the West (had) in stock" put Laika in orbit aboard Sputnik 2?

When designing an adventure, how can I ensure a continuous player experience in a setting that's likely to favor TPKs?

What is the difference between a Hosaka, Ono-Sendai, and a "deck"?

How can electric field be defined as force per charge, if the charge makes its own, singular electric field?

Is this Android phone Android 9.0 or Android 6.0?

What are the basics of commands in Minecraft Java Edition?

What would be the safest way to drop thousands of small, hard objects from a typical, high wing, GA airplane?

Is there an English equivalent for "Les carottes sont cuites", while keeping the vegetable reference?

Where do the electrons come from to make the carbon stable during bombardment of alpha particles on beryllium

My credit card has no magnetic stripe. Is this a problem in the USA?

Should I be able to keep my company purchased standing desk when I leave my job?

Removing milliseconds using datediff

Can I concatenate multiple MySQL rows into one field?How do I limit the number of rows returned by an Oracle query after ordering?SQL Server: How to Join to first rowNested select statement in SQL ServerDATEDIFF Getting the previous monthDATEDIFF() Parameter IssueSQL datediff = N in where does not workHow to use DateDiff into only one SELECT statement?Datediff function results in overflow only in WHERE clause?SQL - How to exclude negative values from datediff function

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

The query is returning milliseconds which I want to remove

SELECT FOLIO_NUMBER, TERMINAL_NAME, ORDER_ENTRY_TIME, START_LOAD_TIME, END_LOAD_TIME,
 datediff(mi, ORDER_ENTRY_TIME, START_LOAD_TIME) AS STAGING_MINUTES,
 datediff(mi, START_LOAD_TIME, END_LOAD_TIME) AS LOADING_MINUTES,
 datediff(mi, ORDER_ENTRY_TIME, END_LOAD_TIME) AS TERMINAL_MINUTES 
FROM ORDERS 
JOIN TERMINAL_OWNER ON ORDERS.LOADING_TERMINAL_ID = TERMINAL_OWNER.TERMINAL_ID
WHERE TERMINAL_ID = '1913' AND FOLIO_NUMBER >= '20190101' AND FOLIO_NUMBER <= '20190201'
ORDER BY FOLIO_NUMBER ASC

sql datediff milliseconds

share|improve this question

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can anyone assist me?
  
  – Arri Benson
  Mar 26 at 12:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure you're using mi and not ms?
  
  – Derrick Moeller
  Mar 27 at 11:44
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please tag your dbms (I suppose Sql Server)
  
  – Joe Taras
  Mar 27 at 11:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  mi = minutes; ms = milliseconds. See here: docs.microsoft.com/it-it/sql/t-sql/functions/…
  
  – Joe Taras
  Mar 27 at 11:50
  

  
  
  
  

add a comment | 

0

The query is returning milliseconds which I want to remove

SELECT FOLIO_NUMBER, TERMINAL_NAME, ORDER_ENTRY_TIME, START_LOAD_TIME, END_LOAD_TIME,
 datediff(mi, ORDER_ENTRY_TIME, START_LOAD_TIME) AS STAGING_MINUTES,
 datediff(mi, START_LOAD_TIME, END_LOAD_TIME) AS LOADING_MINUTES,
 datediff(mi, ORDER_ENTRY_TIME, END_LOAD_TIME) AS TERMINAL_MINUTES 
FROM ORDERS 
JOIN TERMINAL_OWNER ON ORDERS.LOADING_TERMINAL_ID = TERMINAL_OWNER.TERMINAL_ID
WHERE TERMINAL_ID = '1913' AND FOLIO_NUMBER >= '20190101' AND FOLIO_NUMBER <= '20190201'
ORDER BY FOLIO_NUMBER ASC

sql datediff milliseconds

share|improve this question

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can anyone assist me?
  
  – Arri Benson
  Mar 26 at 12:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure you're using mi and not ms?
  
  – Derrick Moeller
  Mar 27 at 11:44
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please tag your dbms (I suppose Sql Server)
  
  – Joe Taras
  Mar 27 at 11:49
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  mi = minutes; ms = milliseconds. See here: docs.microsoft.com/it-it/sql/t-sql/functions/…
  
  – Joe Taras
  Mar 27 at 11:50
  

  
  
  
  

add a comment | 

The query is returning milliseconds which I want to remove

SELECT FOLIO_NUMBER, TERMINAL_NAME, ORDER_ENTRY_TIME, START_LOAD_TIME, END_LOAD_TIME,
 datediff(mi, ORDER_ENTRY_TIME, START_LOAD_TIME) AS STAGING_MINUTES,
 datediff(mi, START_LOAD_TIME, END_LOAD_TIME) AS LOADING_MINUTES,
 datediff(mi, ORDER_ENTRY_TIME, END_LOAD_TIME) AS TERMINAL_MINUTES 
FROM ORDERS 
JOIN TERMINAL_OWNER ON ORDERS.LOADING_TERMINAL_ID = TERMINAL_OWNER.TERMINAL_ID
WHERE TERMINAL_ID = '1913' AND FOLIO_NUMBER >= '20190101' AND FOLIO_NUMBER <= '20190201'
ORDER BY FOLIO_NUMBER ASC

sql datediff milliseconds

share|improve this question

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

SELECT FOLIO_NUMBER, TERMINAL_NAME, ORDER_ENTRY_TIME, START_LOAD_TIME, END_LOAD_TIME,
 datediff(mi, ORDER_ENTRY_TIME, START_LOAD_TIME) AS STAGING_MINUTES,
 datediff(mi, START_LOAD_TIME, END_LOAD_TIME) AS LOADING_MINUTES,
 datediff(mi, ORDER_ENTRY_TIME, END_LOAD_TIME) AS TERMINAL_MINUTES 
FROM ORDERS 
JOIN TERMINAL_OWNER ON ORDERS.LOADING_TERMINAL_ID = TERMINAL_OWNER.TERMINAL_ID
WHERE TERMINAL_ID = '1913' AND FOLIO_NUMBER >= '20190101' AND FOLIO_NUMBER <= '20190201'
ORDER BY FOLIO_NUMBER ASC

share|improve this question

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

share|improve this question

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

edited Mar 27 at 11:46

Derrick Moeller

2,83422 gold badges1414 silver badges3535 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges

asked Mar 26 at 9:11

Arri BensonArri Benson

1433 bronze badges