convert time interval to int in sql
Solutions on MaxInterview for convert time interval to int in sql by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "convert time interval to int in sql"
Hannah
25 Nov 2017
1# The 'time_interval' is the variable/column name.
2
3EXTRACT (epoch FROM time_interval)
4#This gives you the value of the interval in seconds.
5#Divide it by the number of seconds per period to get it in other time duration formats.
6#Eg. minutes, days, hours etc.
7
8EXTRACT (epoch FROM time_interval)/60 #for minutes
9
10EXTRACT (epoch FROM time_interval)/3600 #for hours
11
12EXTRACT (epoch FROM time_interval)/86400 #for days...
13
14similar questions
sql between date rangesql cast date to 103sql int vs integertime in sql serverconvert varchar to int in sqlitesql tinyint rangeconvert float to int sqlsql convert to integer from decimalhow to convert datetime to varchar sqlsql server convert string to datesql datatypes rangeconvert series number to date in sqlconvert int to varchar sqlsql datetime as dateprint intervals of 15 minutes in sql querysql min datetimesql convert datetime to yearsql convert datesql cast to integerconvert time string into 12 hours in sqlsql convert datetime to year monthconvert data type in sql your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful