Java Doc for DateTimeDataValue.java in » Database-DBMS » db-derby-10.2 » org » apache » derby » iapi » types » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation

1.	6.0 JDK Core
2.	6.0 JDK Modules
3.	6.0 JDK Modules com.sun
4.	6.0 JDK Modules com.sun.java
5.	6.0 JDK Modules sun
6.	6.0 JDK Platform
7.	Ajax
8.	Apache Harmony Java SE
9.	Aspect oriented
10.	Authentication Authorization
11.	Blogger System
12.	Build
13.	Byte Code
14.	Cache
15.	Chart
16.	Chat
17.	Code Analyzer
18.	Collaboration
19.	Content Management System
20.	Database Client
21.	Database DBMS
22.	Database JDBC Connection Pool
23.	Database ORM
24.	Development
25.	EJB Server geronimo
26.	EJB Server GlassFish
27.	EJB Server JBoss 4.2.1
28.	EJB Server resin 3.1.5
29.	ERP CRM Financial
30.	ESB
31.	Forum
32.	GIS
33.	Graphic Library
34.	Groupware
35.	HTML Parser
36.	IDE
37.	IDE Eclipse
38.	IDE Netbeans
39.	Installer
40.	Internationalization Localization
41.	Inversion of Control
42.	Issue Tracking
43.	J2EE
44.	JBoss
45.	JMS
46.	JMX
47.	Library
48.	Mail Clients
49.	Net
50.	Parser
51.	PDF
52.	Portal
53.	Profiler
54.	Project Management
55.	Report
56.	RSS RDF
57.	Rule Engine
58.	Science
59.	Scripting
60.	Search Engine
61.	Security
62.	Sevlet Container
63.	Source Control
64.	Swing Library
65.	Template Engine
66.	Test Coverage
67.	Testing
68.	UML
69.	Web Crawler
70.	Web Framework
71.	Web Mail
72.	Web Server
73.	Web Services
74.	Web Services apache cxf 2.0.1
75.	Web Services AXIS2
76.	Wiki Engine
77.	Workflow Engines
78.	XML
79.	XML UI

Java

Java Tutorial

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database DBMS » db derby 10.2 » org.apache.derby.iapi.types

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.apache.derby.iapi.types .DateTimeDataValue

All known Subclasses:   org.apache.derby.iapi.types .SQLDate,  org.apache.derby.iapi.types .SQLTime,  org.apache.derby.iapi.types .SQLTimestamp,
DateTimeDataValue
public interface DateTimeDataValue extends DataValueDescriptor(Code)

Field Summary
final public static int DAY_FIELD

final public static int DAY_INTERVAL

final public static int FRAC_SECOND_INTERVAL

final public static int HOUR_FIELD

final public static int HOUR_INTERVAL

final public static int MINUTE_FIELD

final public static int MINUTE_INTERVAL

final public static int MONTH_FIELD

final public static int MONTH_INTERVAL

final public static int QUARTER_INTERVAL

final public static int SECOND_FIELD

final public static int SECOND_INTERVAL

final public static int WEEK_INTERVAL

final public static int YEAR_FIELD

final public static int YEAR_INTERVAL


Method Summary
NumberDataValue getDate(NumberDataValue result)
     Get the day of the month.
NumberDataValue getHours(NumberDataValue result)
     Get the hour of the day out of a time or timestamp.
NumberDataValue getMinutes(NumberDataValue result)
     Get the minute of the hour out of a time or timestamp.
NumberDataValue getMonth(NumberDataValue result)
     Get the month number out of a date.
NumberDataValue getSeconds(NumberDataValue result)
     Get the second of the minute out of a time or timestamp.
NumberDataValue getYear(NumberDataValue result)
     Get the year number out of a date.
DateTimeDataValue timestampAdd(int intervalType, NumberDataValue intervalCount, java.sql.Date currentDate, DateTimeDataValue resultHolder)
     Add a number of intervals to a datetime value.
NumberDataValue timestampDiff(int intervalType, DateTimeDataValue time1, java.sql.Date currentDate, NumberDataValue resultHolder)
     Finds the difference between two datetime values as a number of intervals.

Field Detail
DAY_FIELD
final public static int DAY_FIELD(Code)

DAY_INTERVAL
final public static int DAY_INTERVAL(Code)

FRAC_SECOND_INTERVAL
final public static int FRAC_SECOND_INTERVAL(Code)

HOUR_FIELD
final public static int HOUR_FIELD(Code)

HOUR_INTERVAL
final public static int HOUR_INTERVAL(Code)

MINUTE_FIELD
final public static int MINUTE_FIELD(Code)

MINUTE_INTERVAL
final public static int MINUTE_INTERVAL(Code)

MONTH_FIELD
final public static int MONTH_FIELD(Code)

MONTH_INTERVAL
final public static int MONTH_INTERVAL(Code)

QUARTER_INTERVAL
final public static int QUARTER_INTERVAL(Code)

SECOND_FIELD
final public static int SECOND_FIELD(Code)

SECOND_INTERVAL
final public static int SECOND_INTERVAL(Code)

WEEK_INTERVAL
final public static int WEEK_INTERVAL(Code)

YEAR_FIELD
final public static int YEAR_FIELD(Code)

YEAR_INTERVAL
final public static int YEAR_INTERVAL(Code)

Method Detail
getDate
NumberDataValue getDate(NumberDataValue result) throws StandardException(Code)
Get the day of the month.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the day of the month.
exception:
  StandardException - Thrown on error

getHours
NumberDataValue getHours(NumberDataValue result) throws StandardException(Code)
Get the hour of the day out of a time or timestamp.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the hour of the day.
exception:
  StandardException - Thrown on error

getMinutes
NumberDataValue getMinutes(NumberDataValue result) throws StandardException(Code)
Get the minute of the hour out of a time or timestamp.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the minute of the hour.
exception:
  StandardException - Thrown on error

getMonth
NumberDataValue getMonth(NumberDataValue result) throws StandardException(Code)
Get the month number out of a date.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the month number.
exception:
  StandardException - Thrown on error

getSeconds
NumberDataValue getSeconds(NumberDataValue result) throws StandardException(Code)
Get the second of the minute out of a time or timestamp.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the second of the minute.
exception:
  StandardException - Thrown on error

getYear
NumberDataValue getYear(NumberDataValue result) throws StandardException(Code)
Get the year number out of a date.
Parameters:
  result - The result of the previous call to this method, nullif not called yet. A NumberDataValue containing the year number.
exception:
  StandardException - Thrown on error

timestampAdd
DateTimeDataValue timestampAdd(int intervalType, NumberDataValue intervalCount, java.sql.Date currentDate, DateTimeDataValue resultHolder) throws StandardException(Code)
Add a number of intervals to a datetime value. Implements the JDBC escape TIMESTAMPADD function.
Parameters:
  intervalType - One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL
Parameters:
  intervalCount - The number of intervals to add
Parameters:
  currentDate - Used to convert time to timestamp
Parameters:
  resultHolder - If non-null a DateTimeDataValue that can be used to hold the result. If null thengenerate a new holder startTime + intervalCount intervals, as a timestamp
exception:
  StandardException -

timestampDiff
NumberDataValue timestampDiff(int intervalType, DateTimeDataValue time1, java.sql.Date currentDate, NumberDataValue resultHolder) throws StandardException(Code)
Finds the difference between two datetime values as a number of intervals. Implements the JDBC TIMESTAMPDIFF escape function.
Parameters:
  intervalType - One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL
Parameters:
  time1 -
Parameters:
  currentDate - Used to convert time to timestamp
Parameters:
  resultHolder - If non-null a DateTimeDataValue that can be used to hold the result. If null thengenerate a new holder the number of intervals by which this datetime is greater than time1
exception:
  StandardException -

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.