Default value for Date/Time, Retrieve in Java

  • Thread starter Thread starter guyinATL
  • Start date Start date
G

guyinATL

Guest
Hi, What is the proper way to store in a field if I want to store current date AND time as a timestamp. I chose Date/Time as the data type and General Date in the Format. Now I wanted a timestamp whenever a new row is added so I placed =Date() in the default value but it only shows me the date, not the time?

Second question if you know Java: I retrieve this date in a java.sql.date and .toString() shows me the correct result in the default format but when i use the DateFormat.format() method on it, i get a Null Pointer Exception. What could be the problem? Thanks! Mr. R :)
 

Users who are viewing this thread

Back
Top Bottom