Date Operations in different databases

srikumar_l · #1 (**permalink**) 12-04-2007, 01:28 AM

Date Operations in different databases

1. Microsoft SQL Server

SELECT GETDATE()

2. MySQL [retrieving the date but not time]

SELECT CURDATE();

3. MySQL [retrieving date and time]

SELECT NOW();

4. Oracle

SELECT SYSDATE FROM dual;

5. PostgreSQL

SELECT CURRENT_DATE;

priyan · #2 (**permalink**) 12-04-2007, 02:59 AM

Quote:

2. MySQL [retrieving the date but not time]

SELECT CURDATE();

You can use SYSDATE() function to get the date and time values. Sysdate() will return the date and time in 'YYYY-MM-DD HH:MM:SS' format.

Murali · #3 (**permalink**) 12-04-2007, 06:01 AM

hi techies,

can we able to set default current date for a table column in MySQL?

priyan · #4 (**permalink**) 12-04-2007, 07:59 AM

Hi, check out this...

Code:

mysql> create table tbl_test (id integer, dt timestamp default now());

mysql> insert into tbl_test(id) values(1);

mysql> insert into tbl_test(id) values(2);

mysql> SELECT * FROM tbl_test;
+------+---------------------+
| id   | dt                  |
+------+---------------------+
|    1 | 2007-12-04 20:38:50 |
|    2 | 2007-12-04 20:38:51 |
+------+---------------------+
2 rows in set (0.00 sec)

Hope this is your requirement ...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert a date in milliseconds back to a date string	itbarota	HTML, CSS and Javascript Coding Techniques	2	03-03-2008 09:03 PM
How can I show the documents last modified date in the format: month, date, year, tim	Pvinothkumar	HTML, CSS and Javascript Coding Techniques	3	12-28-2007 05:58 AM
How can I compare a date in a string with todays date?	itbarota	HTML, CSS and Javascript Coding Techniques	2	12-18-2007 11:02 PM
String Operations using different databases	srikumar_l	Database Support	0	12-05-2007 03:27 AM
How to convert a date to a globally accepted date format, in DOT NET 2005?	Archer	C# Programming	1	07-25-2007 03:21 AM