Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Sql Query
- i have one complecated sql quert please help me in that the situation is like this i have one table likebilltable nameid,date,status in that status is always 1 or 0 and other table likebilldetailtable nameid,bill_idfk of first table,itm_idfk of third table,amountother table is itmtable nameid,namenow i want to create one...
- Tags: akshar108@..., SQL, TO_DATE
- Discussion threads 2007-01-25
Additional Resources
- Date and Time Field Types
- I am working with a database in which the administrator has made a Date and Time field as a "text" type field. Now when I want to define a "between" date parameter, in my query, it won't pull the proper information. The Field is displayed as shown:...
- Tags: Databases, kwis@...
- Discussion threads 2004-12-03
- asp:calendar in gridview isn't updating
- Hi Guys,I encountered weird problem where the similar code runs well in one page and partially working on the other.In both page, I have gridiview which has an edit command button. Page A is the working page, Page B partially working (can update the proj_name but not the from_date and...
- Tags: Databases, jackmuliadi@..., Page B., Page B, Container.DataItem
- Discussion threads 2007-08-28
- Learn Oracle: Datatypes for SQL and PL/SQL, Dates
- Use the article index for more articles on this subject.Oracle10g provides three types of date related datatypes: date, timestampsand intervals. Today I will be talking about all three of these.DATETheDATE datatype is a datetime datatype. It stores a date and a time. Thedate portion is based on the number of...
- Tags: Oracle Corp., PL/SQL, SQL, these.DATEThe DATE
- Blog posts 2006-08-07
- Use DBMS_RANDOM to generate text and date values
- The PL/SQL package DBMS_RANDOM can generate random text and date values as well as numbers. Check out these code examples to learn how you can generate these values in your development work. Numbers, text strings, and dates are three common datatypes used in tables. Although you would expect...
- Tags: Oracle Corp., Databases, Bob Watkins, integer, SELECT DBMS_RANDOM.VALUE, DBMS_RANDOM, random date, Oracle Tips Newsletter, DUAL, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-05-09
- Round and truncate dates in Oracle
- watch outAlthough truncing a date is very common, I didn't know about the format parameter.Thanks.trunc(sysdate,'y') sure beats to_date('01-01-'||to_char(sysdate,'yyyy'),'dd-mm-yyyy')However while playing around I noticed something I didn't expect, using the 'd' format.I expected the output of trunc(sysdate,'d') to basically be the same as truncsysdate.Because truncing to a day would in my...
- Tags: bellyware, SysDate, Oracle Corp.
- Discussion threads 2007-07-25
- Oracle Tip: Create linguistic helper functions in SQL
- You can generalize simple tasks in a globalized environment by breaking down a particular language into a set of grammar rules and exceptions to those rules. Scott Stephens demonstrates how you can you do just that in SQL. In a globalized environment, many simple tasks become more difficult...
- Tags: Scott Stephens, Oracle Tips Newsletter, Function, Grammar, Integer, Oracle Corp., Problem, SQL, Limitation, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2004-09-01
- Round and truncate dates in Oracle
- We usually think of rounding as applying only to numeric values: If the digit to the right of where you want to round is 0-4, round down; if it's 5-9, round up. In Oracle, the ROUND function is used for this: The expression ROUND(12.34, 1) evaluates to 12.3, and the...
- Tags: oracle, databases
- Blog posts 2007-07-24
- << Previous
- page 1 of 1
- Next >>
