.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Velemoochi
Imran Ghani
Post New Web Links

how i can calculate date difference in oracle

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :ASP.Net
 
how i can calculate the date diff in Oracle 10g using pl sql developer 7thank you


View Complete Post


More Related Resource Links

Calculate Future Age and Date

  
I hope someone can help me. I am new to SharePoint and I was given the task to determine all the people who will be age 65 in 90 days from today (meaning current date), and display them in a list. I haven't a clue how to do that. By the way, we are still using version 2003. I would very much appreciate the help. Thanks! Kelly  

MOSS 2007 Calculate Due Date including working hours and working days

  
Hi, I've searched many forums for an answer to my problem but with very limited success. Basically, I've created a Sharepoint list where I would like to track a resolution of incidents versus SLA timings. I have a column with a receiving date, which is a date when the request was submitted and another column with priority code where I have 3 possible values: low (5 working days to close the request), medium (3 days) and high (1 day). What I would like to do is to automatically calculate due date for solving the incident based on the receiving date and the priority code. The thing is that now it is getting more complicated since I need to exclude saturdays and sundays from calculation, as well as national holidays. Then I would like to take into account working hours (from 8am to 4pm), for example if an incident with medium priority was submitted on Friday 5pm, then it would have its due date set to Wednesday 4pm (the request was sent after working hours so we have 3 full working days to complete it) Not sure if it is feasible to achieve using formulas, maybe some other way?

How to calculate difference between two dates in years

  

hi all, 

i need to know if, given a birth date, a person has more than x years. Thats mean, the client must entry a date in a textbox and i need to know if the persona has more than 18 years. 


Thx in advance


How to calculate days from two date textbox?

  

have two text box on which I give two date input by using rapid application development datepicker textbox. I have another text box on which I wanna show the duration of those two text box date.
I want to calculate total days of those to date. Can anyone please provide me a solution?


date not save in oracle databse

  

here is my function

Public Shared Function GetData(ByVal strQuery As String) As DataTable
        Dim dt As New DataTable
        Dim cmd As New OracleCommand(strQuery, conn)
        cmd.CommandType = CommandType.Text
        Try
            conn.Open()
            da.SelectCommand = cmd
            da.Fill(dt)
        Catch ex As Exception
            Return dt
        Finally
            conn.Close()
            cmd.Dispose()
            da.Dispose()
        End Try
        Return dt
    End Function


here im calling above GetData function

 Protected Sub ImageButton

Date Difference Calculation

  

Hi there,

I have 2 date columns as follows:

Due Date Submission Date
31-Jan-2010 30-Jan-2010
20-Apr-2010
16-Mar-2010 20-Mar-2010

now based on the above 2 dates i need to create an sproc for generating the following table with the given validation

<

Calculate delta difference in the same table

  
Hello,

The following is the table creation and records insertion script

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[students] (
[studentid] [int] NULL,
[paymentdate] [date] NULL,
[pmtamt] [decimal](20, 2) NULL
) ON [PRIMARY]

GO

INSERT INTO [students] ([studentid] ,[paymentdate] ,[pmtamt])
VALUES
('1','2009-06-03','135.00'),
('2','2008-03-02','456.78'),
( '1','2008-06-03','654.00'),
('1', '2007-04-08','7895.00'),
('1','2010-06-03','427.00'),
('2','2009-07-08','3544.00'),
('3','2010-07-08','564.00'),
('3','2009-06-08','423.54'),
('3','2007-03-08','2342.00')

I need to find out the delta difference in payments between different years for each student.

I have been working on the following code

select A.studentid
, A.[year] , b.[year],
a.avgpmtamt,

date format conversion from oracle to sql using SSIS

  

HEllo friends

I am migration oracle tables to sql using SSIS. While doing this i am trying to use Derived column transfrom to convert Date format in oracle to sql. But i do not have any clue that how should i use this. In oracle side date is in mm/dd/yy format and in sql i want that in yy/mm/dd format. 

Please give me directions ASAP?

Thanks in advance


dimrd_SQL

INFOPATH: how can I calculate hours between 2 date fields in a list form

  

I am trying to calculate the number of hours between 2 date/time fields in a list form.

If I do this on a list view level with a calculated column, the column is not available for column summaries. Therefor I intend to use a regular number column and calculate the hours in an InfoPath form. Obviously the formula for calculated fields in list columns will not work in InfoPath.

Addition: I tried DateField1-DateField2, but the result is NaN...

Suggestions? 

Thx


Iko

function to calculate number of business days in a month for a given date

  

hi ,

Is there any function to calculate number of business days in a month for a particular date.  my input would be just a single date

thanks,

Vishal


Date difference

  

Hi All,

   I have a column called Conduct Date with 5 different dates for a single ID. for example my table structure is as follows

ID              Conduct date

1                 2010-01-31 00:00:00    

1                 2010-03-31 00:00:00

1                 2010-09-30 00:00:00

1                 2010-12-21 00:00:00 

1                 2010-10-30 00:00:00

Now i need to find the date difference between last two dates that have the maximum value. For example in the above case the dates to be taken for calculation are

2010-12-21 00:00:00 and 2010-10-30 00:00:00

Please let me know how to achieve this.

Thanks and regards,

Ram


Excel Date Field Import Problem in Oracle SQL Developer

  

Hi All,

I have an Excel file (which has data imported from Oracle 10G Database) one of the fields is a Date Filed which has values like 28-JAN-11 03.25.11.000000000 PM ( Date field is Oracle Time Stamp(6) in Database )

When I am trying to Import the same Excel file from another Oracle 10 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 10G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)

How can I import that field ?? For time being I made the TIMESTAMP to VARCHAR2 and its working but I could not convert that to Date field again in C# CODE ( it says not a valid date type).


Excel Date Field Import Problem in Oracle SQL Developer

  

Hi All,

I have an Excel file (which has data imported from Oracle 10G Database) one of the fields is a Date Filed which has values like 28-JAN-11 03.25.11.000000000 PM ( Date field is Oracle Time Stamp(6) in Database )

When I am trying to Import that Excel file from another Oracle 10 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 10G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)

How can I import that field ?? For time being I made the TIMESTAMP to VARCHAR2 and its working but I could not convert that to Date field again in C# CODE ( it says not a valid date type).

 


Using a CompareValidator to check input is a valid date

  
The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

How To Set a Date Format In GridView Using ASP.NET 2.0

  
A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

jQuery Date picker Implementation in ASP.NET

  
I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

What is the difference between "dynamic" and "object" keywords?

  
Let's take a quick look at the object keyword first. I'm not going to talk a lot about it because it's been around since C# 1.0. This keyword is nothing more than a shortcut for System.Object, which is the root type in the C# class hierarchy. (However, as Eric Lippert pointed out in his blog post, not everything in C# derives from object.) This is a powerful mechanism, since you can assign almost any value to instances of this type.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend