Share on Google+Share on Google+

Anthony Maniquiz
Getting Computer Date in java
3 Answer(s)      5 years and a month ago
Posted in : Java Beginners

Hi , I want to get the PC Date and insert it to a DB, specifically MSSQL.. Everything in my scriptlet works but this..

String strDate = new Date();

I get this server error, "The type Date is ambiguous".

I've also tried Date date = new Date(); ... but it get's the same error.

Also, I want the date format to come out something like this.. 10-24-2012..

Can anyone help??

Ads

View Answers

February 28, 2012 at 5:55 PM


date datatype should be of varchar type.

import java.sql.*;
import java.util.*;
import java.text.*
class  InsertDate{
    public static void main(String[] args){
    try{
        java.util.Date d=new java.util.Date();
        SimpleDateFormat sdf=new SimpleDateFormat("MM-dd-yyyy");
        String st=sdf.format(d);
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );

        Statement pstmt = conn.createStatement();
        String INSERT_RECORD = "insert into person(dob) values('"+st+"')";
        pstmt.executeUpdate(INSERT_RECORD);
        pstmt.close();
        conn.close();
    }
    catch(Exception e){
        e.printStackTrace();
    }
  }
}


February 28, 2012 at 6:03 PM


The package java.util.* and java.sql.*, both are having Date class. Therefore this error occurs. Use classes with their package as well like if you are using Date class of util package then use it as java.util.Date and if you are using java.sql.Date then use it as java.sql.Date.



February 28, 2012 at 6:41 PM


Thanks ! Helped Very Much ! :D










Related Tutorials/Questions & Answers:
Getting Computer Date in java
Getting Computer Date in java  Hi , I want to get the PC Date... but this.. String strDate = new Date(); I get this server error, "The type Date is ambiguous". I've also tried Date date = new Date(); ... but it get's the same error
Get computer name in java
Get computer name in java       We can get the computer name by the java code program. For getting computer name we have used java.net.InetAddress class. We will use static
Advertisements
Date not getting in proper format
Date not getting in proper format  import java.util.*; class Date { public static void main(String[]args) { Date d = new Date(100000000000L); System.out.print("1st date"+d.toString()); } } out put:- 1st date@3e25
getting current date without using system date - Date Calendar
getting current date without using system date  I want to get the current date but the Java code should not get System date as Current date. Pleae help me in getting current date without using system date. thanks in Advance
Getting the current date
Getting the current date     ... date of the system. In this section, through the given program you can get the current date in the proper format (Day/Month/Year). This program shows
computer configuration - Java Beginners
computer configuration  someone posted a code but tha is not working and i am totaly new to java and i hae to submit my project kindly help and send a working code Create a class Computer that stores information about
java with computer network
java with computer network  i feel it's very difficult to use java for network programming. how can i recover this problem?give me any simple example... that explains the java for network programming Overview of Networking through JAVA
computer management - Java Beginners
computer management  Create a class Computer that stores information... to be stored about a single computer is, - Company Name - RAM size... array of 4 objects of Computer class and that takes input for all above
Computer dealer management - Java Beginners
Computer dealer management  Create a class Computer that stores.... The information to be stored about a single computer is, - Company Name - RAM size... ( ) method that creates array of 4 objects of Computer class and that takes input for all
Computer Scince 1015 - Java Beginners
Computer Scince 1015  Write a SavingsAccount class to store the following information related to a bank account: Account number, Password, Branch name, Surnames, First names, Balance The account balance should be able
Computer forensic application development using JAVA program
Computer forensic application development using JAVA program  Write a computer forensic application program in Java for Recovering Deleted Files and Deleted Partitions
Getting the Records in PL/SQl between Date Ranges - JDBC
Getting the Records in PL/SQl between Date Ranges  Getting the records Between the Dates in PL/SQL Database by using JDBC and display through JSP
Getting the modification date and time of file or folder in Java
C:\nisha>java GetDirectoryAndFileModifiedTime Enter file or directory name in proper format to get the modification date and time : myfile.txt File name : myfile.txt File modification date
getting random number in java
getting random number in java  getting random number in java Hi... random numbers between 1 to 100 in Java. Though i m new to Java, i have tried many... in my Java application but nothing seems to work. In order to get the random
Getting Started With Java
Getting Started With Java       JDK 6 Tutorial The latest news for the java programmers that the Sun MicroSystems has released the Java SE 6 on Monday December 11.  
Getting A File's Mime Type In Java
Getting A File's Mime Type In Java  Getting A File's Mime Type In Java
Getting date by time
Getting date by time       In this example of creating date using the timestamp value. We can... DateByTime.java C:\DateExample>java DateByTime New Date:=Sun Jan 25
Java Date conversion - Date Calendar
Java Date conversion  How do I convert 'Mon Mar 28 00:00:00 IST 1983' which is a java.util.Date or String to yyyy/MM/dd date format in sql
How to find version of Java installed on my computer? - Java Beginners
How to find version of Java installed on my computer?  How to get... with many more new features.How to find version of Java installed on my computer?To find out the version of Java installed on your computer, just type Java
Getting Previous, Current and Next Day Date
Getting Previous, Current and Next Day Date   ... previous, current and next date in java. The java util package provides... the previous, current and next date to Date() constructor of java.util package
Java Date
The Java Date class allows the developers to manipulate date and time from within the Java program. The Java Date class is very useful class and it is used... in your program you will have to use the Java Class to manipulate the date
Getting environment variable value from java
Getting environment variable value from java  Getting environment variable value from java
Mysql Date To Java Date
Mysql Date To Java Date       Mysql Date To Java Date retrieve the records from Mysql and display the date in java. Understand with Example The Tutorial illustrate an example from
Getting 404 errors - Java Beginners
Getting 404 errors  Dear experts, I have embedded a login page inside my landing page - home.jsp. So, at the right-hand column of my page, I use the below codes:- Login
how to add date and change date in java - netbeans
how to add date and change date in java - netbeans  I need to code use to increase date How to get date after 30 days using netbeans
java yesterday - Date Calendar
java yesterday  Afternoon,Yesterday i have a question that how to make date sustract, the result is to make 1 month and 1 day like this, right. now how about 1 year and 1 month? And Can help me to using Date Calender what
java Date - Java Beginners
java Date  Dear sir I have an assignment, It is .. "Develop Date class in java similar to the one available in java.util package.Use JavaDoc..., Try the following code: public class Date { private final int month
java - Date Calendar
Java convert string to date  I need an example in Java to convert the string to date.  Convert string to date formatimport... str_date="04-04-2008"; DateFormat formatter ; Date date
Installing Java (JDK 7) on Windows 7 Computer Video Tutorial
to download and configure JDK 7 on your windows 7 computer. To learn the Java... JDK 7 on your computer. To make your computer ready for Java Programming you...- version' and the version of java installed on your computer will be displayed
Getting Current Directory from java - Java Beginners
Getting Current Directory from java  I'm designing an application in linux where i need to get the current directory of my java file... I'm using...://www.roseindia.net/java/java-get-example/get-CWD.shtml http://www.roseindia.net/java
date picker - Java Beginners
date picker  sir i need code for date picker in java swing because for Embedding in my project plz sir
Tutorials   
Java Spring Hibernate Struts Training What does core Java include? java What are some way to learn Java quickly? Is it required to learn Java before learning Java Script? Is it necessary to learn java script before learning PHP? Are HTML5 and Java Script boosts Java career? Is Java object oriented? Fingerprint application with Java Uninstall Oracle Virtual Box JSON to HashMap Free Java online Training I want example of Control Statement in Java ANSI Color Codes with Python Create a Program that Calculates Input What is difference between JDK,JRE and JVM? How to see ubuntu version on server? How to get Page Source in Selenium (WebDriver) using Java? The path to the driver executable must be set by the webdriver.gecko.driver system property parse data from a link in java Java Program Qns using BlueJ How to fix HAX Kernel Module Is Not Installed error? Installing Audacity Looking for code Logic to check track changes & Coments in MSWord, MSWordx, MSExcel, MSExcelx is ON/OFF Installing JDK on Mac SAX Parser exception ERROR 601 (42P00): Syntax error. Encountered Thread java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory How to install Ubuntu 16.04 LTS? HttpServletRequest cannot be resolved to a type in eclipse - Solved Unhandled event loop exception GC overhead limit exceeded Spring Data jpa with apache phoenix Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF o.a.h.h.z.RecoverableZooKeeper - Possibly transient ZooKeeper, quorum= com.thinkaurelius.titan.diskstorage.hbase.HBaseStoreManager class not found com.thinkaurelius.titan.diskstorage.hbase.HBaseStoreManager not found How to download and install Java 8 on Windows? How to uninstall JDK 7? How to install gtk-doc-tools package in Ubuntu? How to install Oracle JDK 8 on Ubuntu? ejabberd_ctl.beam not found - Solved How to convert date to UTC format in Java? How to install autoconf, automake and libtool in Ubuntu 15.10? How to convert current date to mm dd yyyy format in Java? How to convert current date to dd mm yyyy format in Java? How to stop window closing in "internalFrameClosing" event. How to find list of all index in Neo4j? neo4j-server.properties file location SASLError using PLAIN: not-authorized how to convert war file into .exe file using java code

Ads

 
Advertisement null

Ads