DATETIME insert 
Author Message
 DATETIME insert
Hi!

Is there a routine such as DATE(TODAY) i.e wich can insert into DATE
attribute current DATE valid for DATETIME attribute type too?

I tried to use DATE(TODAY) on DATETIME attribute but I get all 00:00:00
inside.

My DATETIME is defined as:
DATETIME HOUR TO SECOND.

Thanks!



Sun, 06 Jun 2004 21:16:35 GMT
 DATETIME insert

Try current instead of date.

--
Jay Aymond
Community Coffee Company
Baton Rouge, LA
www.communitycoffee.com

Quote:
> Hi!

> Is there a routine such as DATE(TODAY) i.e wich can insert into DATE
> attribute current DATE valid for DATETIME attribute type too?

> I tried to use DATE(TODAY) on DATETIME attribute but I get all 00:00:00
> inside.

> My DATETIME is defined as:
> DATETIME HOUR TO SECOND.

> Thanks!



Sun, 06 Jun 2004 22:20:47 GMT
 DATETIME insert

You should be able to use CURRENT which is the same as TODAY except it
includes the time.

Quote:
-----Original Message-----

Sent: Wednesday, December 19, 2001 7:17 AM

Subject: DATETIME insert

Hi!

Is there a routine such as DATE(TODAY) i.e wich can insert into DATE
attribute current DATE valid for DATETIME attribute type too?

I tried to use DATE(TODAY) on DATETIME attribute but I get all 00:00:00
inside.

My DATETIME is defined as:
DATETIME HOUR TO SECOND.

Thanks!



Sun, 06 Jun 2004 23:04:39 GMT
 DATETIME insert


Quote:
> Try current instead of date.

That solved it.

Thanks!



Sun, 06 Jun 2004 23:44:54 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. DateTime insert Problem

2. Datetime insert problem

3. datetime insert problem

4. datetime insert/update problem

5. datetime insert/update

6. How to Insert Null in SQL Server DATETIME from ASP

7. insert time into datetime field with SQL?

8. bulk insert with data type DateTime

9. How to insert null into Datetime field?

10. Help! Insert datetime into SQL Server

11. insert current datetime

12. how can i insert a blank value for datetime field


 
Powered by phpBB® Forum Software