Saturday, August 30, 2025
HomeLanguagesJavaJava SQL Timestamp getNanos() function with examples

Java SQL Timestamp getNanos() function with examples

The getNanos() function is a part of Timestamp class of Java SQL.The function is used to get the fractional part of the seconds value of the Timestamp Object. The function returns the object’s nanos value . Function Signature:

public int getNanos()

Syntax:

ts1.getNanos();

Parameters: The function does not accept any parameter. Return value: The function returns an integer value which is the object’s nanos value Exception: The function does not throw any exception Below examples illustrate the use of getNanos() function Example 1: Create a timestamp and use the getNanos() to get the fractional part of timestamp object. 

Java




// Java program to demonstrate the
// use of getNanos() function
 
import java.sql.*;
 
public class solution {
    public static void main(String args[])
    {
 
        try {
 
            // Create two timestamp objects
            Timestamp ts = new Timestamp(10000);
 
            // Display the timestamp object
            System.out.println("Timestamp time : "
                               + ts.toString());
 
            // Set the value of the fractional part
            // of timestamp object
            // using setNanos function
            ts.setNanos(1000000);
 
            // Display the timestamp object's
            // seconds' fractional part
            System.out.println("New Timestamp time : "
                               + ts.toString());
            System.out.println(" Fractional Part :"
                               + ts.getNanos());
        }
 
        catch (IllegalArgumentException e) {
 
            // Display the error if any error has occurred
            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
 Fractional Part :1000000

Example 2: Create a timestamp and use the getNanos() to get the fractional part of timestamp object and dont set any fractional value of seconds 

Java




// Java program to demonstrate the
// use of getNanos() function
 
import java.sql.*;
 
public class solution {
    public static void main(String args[])
    {
 
        try {
 
            // Create two timestamp objects
            Timestamp ts = new Timestamp(10000);
 
            // Display the timestamp object
            System.out.println("Timestamp time : "
                               + ts.toString());
 
            // Display the timestamp object's
            // seconds' fractional part
            System.out.println("Fractional Part : "
                               + ts.getNanos());
        }
 
        catch (IllegalArgumentException e) {
 
            // Display the error if any error has occurred
            System.err.println(e.getMessage());
        }
    }
}


Output:

Timestamp time : 1970-01-01 00:00:10.0
Fractional Part : 0

Reference: https:// docs.oracle.com/javase/7/docs/api/java/sql/Timestamp.html

RELATED ARTICLES

Most Popular

Dominic
32250 POSTS0 COMMENTS
Milvus
81 POSTS0 COMMENTS
Nango Kala
6617 POSTS0 COMMENTS
Nicole Veronica
11792 POSTS0 COMMENTS
Nokonwaba Nkukhwana
11840 POSTS0 COMMENTS
Shaida Kate Naidoo
6733 POSTS0 COMMENTS
Ted Musemwa
7014 POSTS0 COMMENTS
Thapelo Manthata
6689 POSTS0 COMMENTS
Umr Jansen
6704 POSTS0 COMMENTS