Java SQL Timestamp setNanos() function with examples
Last Updated :
16 Jun, 2022
The setNanos() function is a part of Timestamp class of Java SQL.The function is used to set the fractional part of the second’s value of the Timestamp Object. The function sets the object’s Nanos value to the given value.
Function Signature:
public void setNanos(int t)
Syntax:
ts1.setNanos(l);
Parameters: The function accepts int value t as parameter which is the nanoseconds value to be set.
Return value: The function does not return any value.
Exception: The function throws IllegalArgumentException if the parameter passed is less than 0 or greater than 999999999
Below examples illustrate the use of setNanos() function
Example 1: Create a timestamp and use the setNanos() to set the fractional part of timestamp object.
Java
import java.sql.*;
public class solution {
public static void main(String args[])
{
try {
Timestamp ts = new Timestamp( 10000 );
System.out.println( "Timestamp time : "
+ ts.toString());
ts.setNanos( 1000000 );
System.out.println( "New Timestamp time : "
+ ts.toString());
}
catch (IllegalArgumentException e) {
System.err.println(e.getMessage());
}
}
}
|
Output:
Timestamp time : 1970-01-01 00:00:10.0
New Timestamp time : 1970-01-01 00:00:10.001
Example 2: Create a timestamp and use the setNanos() to set the fractional part of timestamp object and pass negative int value as parameter.
Java
import java.sql.*;
public class solution {
public static void main(String args[])
{
try {
Timestamp ts = new Timestamp( 10000 );
System.out.println( "Timestamp time : "
+ ts.toString());
ts.setNanos(- 1000000 );
System.out.println( "New Timestamp time : "
+ ts.toString());
}
catch (IllegalArgumentException e) {
System.out.println(e.getMessage());
}
}
}
|
Output:
Timestamp time : 1970-01-01 00:00:10.0
nanos > 999999999 or < 0
Reference: https:// docs.oracle.com/javase/7/docs/api/java/sql/Timestamp.html
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...