Convert year into days in SQL

Closed Posted Mar 5, 2015 Paid on delivery
Closed

Hi

Can some one tell me how to convert year into days in SQL .

Like convert 1.1 ( 1 year and one month into days) or 0.5 (5 months)

MySQL Oracle SQL

Project ID: #7250624

About the project

41 proposals Remote project Active Apr 11, 2015

41 freelancers are bidding on average $5/hour for this job

eClickApps

►►►Hi, Greetings from Eclick Softwares and Solutions Pvt. Ltd ◄◄◄ ►► We are a bunch of creative minds working together to provide you with every kind of Graphic Designs with 10+ years of experience bagged by us. We More

$5 USD / hour
(4 Reviews)
5.2
harsh075

Hello, please ping me in pm and i will give you the details immediately. And this will be complementary from my side so will not charge for this. Thank You Harshal

$2 USD / hour
(41 Reviews)
5.4
mrkrunaldoshi

I am Krunal K. Doshi from Ahmedabad, Gujarat, INDIA having 10+ year of experience in IT field having completed majority of projects with Microsoft Technologies. I am placing my bid for this project as it looks chal More

$8 USD / hour
(23 Reviews)
5.3
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$5 USD / hour
(8 Reviews)
4.9
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant More

$10 USD / hour
(36 Reviews)
5.8
igorssv

Hello I can try to help you. But I need to know what is the aim of your conversion. I have an experience of creating various queries for different database servers. Waiting for your response.

$8 USD / hour
(15 Reviews)
4.7
arvindborhade

A proposal has not yet been provided

$5 USD / hour
(8 Reviews)
4.1
thegrchet

SQL Server DBA with 4+ years of experience. I can immediately work on this and help you convert years into months/days Infact I can share the query, after immediately you award this project to me

$8 USD / hour
(6 Reviews)
4.3
softtechsurat

hello sir/madam we know very well how to convert years into days in sql waiting for your relpy give us chance to serve you better Regards, softtechsurat

$2 USD / hour
(16 Reviews)
4.1
imranahsan1

A proposal has not yet been provided

$5 USD / hour
(26 Reviews)
4.5
amraltweky

Hi, with sql you can multiply given years to 365 select year * 365 thanks best regards

$4 USD / hour
(4 Reviews)
3.7
AuDH

Hi, Wish you are doing well. My name is Rellik, I am writing this email to hope that that I will have chance to receive your request. I have experience with sql, pl/sql which will be strong point to help you on this. More

$5 USD / hour
(7 Reviews)
3.6
akilkhatri

Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Regards, Akil Khatri

$8 USD / hour
(8 Reviews)
3.0
boscha

Hi. I am database developer. I know how to convert years to days. It's very simple. Contact me for more information. Thanks

$5 USD / hour
(5 Reviews)
2.9
AHTOAH

Hello, I'm experienced in SQL and have already built similar query for this type of conversion. Let me know if you are interested and I'm ready to discuss the details with you. Regards, Tony

$5 USD / hour
(2 Reviews)
1.5
staritsolution1

Respected Client, Thanks For Your Posting. We read your project Definition and understood what does your project. And we would like to do your project. We make your project according to the amount of bid. We will More

$2 USD / hour
(0 Reviews)
0.0
shilpadadireddy

I have 7 years of experience in PL/SQL.I can do the SQL related stuff easily.I will ensure that I will deliver the deliverables in time.

$5 USD / hour
(0 Reviews)
0.0
vvgvw

Hi! I can do it. If you want, in addition, I can to consult in other of SQL's question. Thanks for attention!

$3 USD / hour
(0 Reviews)
0.0
ankittvyas

I'm a professional web developer and know what your need is. The task is not too difficult. but it would be good if you tell what you exactly want i mean there numerous ways to do this task but what matters is which wa More

$7 USD / hour
(0 Reviews)
0.0
razhev

Good day, If you need sql it's look like this on Oracle: select round((trunc(to_number(&nn))*365)+(substr(to_char(&nn),instr(&nn,',')+1)*365/12),1) from dual where is &nn must be replaced to char '1,10' like: More

$2 USD / hour
(0 Reviews)
0.0