Convert date to number

Advertisement
November 30

Hello.
I want to convert date field to number. I used TIMESTAMPDIFF(SQL_TSI_DAY, "Invoice date (invoice header)".Date, CURRENT_DATE ) to get number of days from invoice date to current day but this number is treated as date format and I'm not able to make calculation on that number. Any suggestions how to convert this »number« to real number that also calculation would be possible.
Thank you.
Brgds, Luka

Advertisement

Replay

Any hint or is not possible as Kishore said....
I would like to sum (grand total) all the days that I get from TIMESTAMPDIFF.
Example:
Invoice nr. Due date TIMESTAMPDIFF(SQL_TSI_DAY, "Invoice due.date (invoice header)".Date, CURRENT_DATE )
201001006978          30.11.2010     44
201001007250          8.12.2010     36
201001007392          15.12.2010     29
201001007735          23.12.2010     21
201001007815          30.12.2010     14
SUM = 144
Brgds,
L

View 5 Replies

Help needed in converting date to number

October 11

Hi, I am trying to execute the below query, its failing with "invalid number" error. select * from process_status where time_process > to_char('&3','yyyymmdd') time_process is the "number" datatype. Details: SQL> select * fro

View All Replies

How to convert date to number

November 30

Hai How to convert the given date into number. Thanks & regards srikkanth.MLook at these posts Please help me in Converting Lilian Format to Date converstion to date and try something like this. SELECT sysdate,sysdate-to_date('15-10-1582','DD-MM-YYYY

View All Replies

Date to number conversion?

October 11

I want to select a number of rows created within last week. To do it I use a select statement with: WHERE sysdate-o.created_on <= days; (days is a number, created_on is a date) Everything works fine, but I get warnings like this one: PLW-07204: conve

View All Replies

Saving result from sp_executesql into a variable and using dynamic column name - getting error "Error converting data type varchar to numeric"

October 11

Im getting an error when running a procedure that includes this code. I need to select from a dynamic column name and save the result in a variable, but seem to be having trouble with the values being fed to sp_executesql DECLARE @retval AS DECIMAL(1

View All Replies

HOW TO CONVERT DATE INTO NUMBERS

October 11

HI, what the syntax for converting date into No. Ex from the first date of the month till current date how many days are there, this No of days needs to be divided by the net sale of the month. i have searched in formulas fields but i am not able to

View All Replies

Is there a way to convert skype online number cont...

October 11

That was the general question, and here are my details: I have had a skype number for many years and it was great, around $5.5 a month to call all phones in North America from my laptop from any place in the world with internet. With time, I had a cc

View All Replies

Oracle apps data type number came over to disco as varchar

November 30

created custom foler ( fnd_flex_values_vl) using sql, one of DFF item ( original data type is number) shows as varchar. Anybody knows how to convert this to number , I tried to_number but still shows as text in Desktop.Sorry, thought you'd said it wa

View All Replies

Problem with converting data types

November 30

Hi Experts, I am stuck up with a little problem, i need your help i am converting all the data types to CHAR but i am not getting the expected data out......... My code is as below...where do i go wrong... LOOP AT <T_ITAB> ASSIGNING <FIELD>. D

View All Replies

Need help in date to number conversion

October 11

Hi, I have a doubt in a date conversion, please help me. I executed the below query, its throwing "invalid number" error. select * from test where date_sid between to_number(to_char('01-05-2009','dd-mm-yyyy'),'yyyymmdd') and to_number(to_char('0

View All Replies

Conversion failed when converting date and/or time from character string

October 11

Hi experts, I'm trying running a query in Microsoft Query but it gives the following error message: "conversion failed when converting date and/or time from character string" when asks me the data I'm inserting 31-01-2014 i've copy the query for

View All Replies

Convert time to number and number to time

November 30

I'm using SAP 4.0b I'm looking for function that converts time to number and number to time. Any suggestion?Hi, Can you give an example of what number you want to give to get what time and vice-versa? There can be a direct conversion between an integ

View All Replies

CONVERTING DATA TO 2 DECIMAL PLACES

November 30

All, I needed to convert a BSO database to only have 2 decimal places. I did this by exporting the data and restricting the export calc to 2 decimal places. HOWEVER - there still appears to be rollups that have more than 2 decimal places. * Is there

View All Replies

Error converting data when updating table

November 30

Hi, I need to understand why I cannot gat my update to work properly, I have to concat 4 fields (numbers with leading zeros so I can create a new number with leading 1. My field is already set as a bigint but I cannot convert the resulting string pro

View All Replies

Decimal of SQL Server getting converted to Whole number in ORACLE

November 30

Hi All, I am using ORACLESQL Developer tool to migrate database from SQL Server to ORACLE. The decimal datatype in Sql Server is not getting converted to its equivalent in ORACLE. Do anyone face the same problem? Its getting converted to WHOLE number

View All Replies

Convert data

November 30

i m trying to use except to match some columns  select [src] from book5 except select [home_phone] from Lead the src column is float, and the home_phone col is char, i m getting this error  Msg 8114, Level 16, State 5, Line 1 Error converting data ty

View All Replies

Converting Exponential to number

November 30

I have a value 1.23365465451346E21 in my database column.i want to convert it into number as display as 1233654654513456546546.What would be the sql query for that.please help.In SQL*Plus: SQL> set numwidth 40 SQL> with t as ( select 1.2336546545134

View All Replies

Syntax error while doing Convert data in LSMW

October 11

Hi experts,       I am using direct input method for uploading customer master records. After display read data step, when i click Convert data button, i get a runtime error saying that:       the data object "LEGACY_CUSTOMER_MASTER" has no comp

View All Replies

Convert data is not writng anythng in LSMW?

October 11

Hi Friends, After uplaoding the data, when I goto convert data step and execute. It reads 2 records but it doesn't write anything. So I am not able to execute the batch input method? I am doing that for Material master? Can any one help me regarding

View All Replies

Error converting data type nvarchar to numeric 'witholding tax' (OWHT)

October 11

Hi Guys. After I have upgraded my clients 2007 PL 30 database to 8.81 PL05, and running a repair to fix inconsistincies, I am receiveing some error when opening any sales documents. It takes place when I open a sales document, or browse previous docs

View All Replies

Tags:

  1. 1020dead soulision
  2. Backup easyserver has stopped
  3. file: C:UsersHPDesktopmemeo.txt
  4. 4.4.2verssion changer app
  5. lenovo a6000 upgrade ing problem
  6. PEXR 2002
  7. difference in fgi0 and ke30
  8. UFE3
  9. stepa89
  10. package4uu
Copyrights 2019 Fcffair BigData Resource, All rights reserved