|
[VIEWED 2828
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
U?Me
Please log in to subscribe to U?Me's postings.
Posted on 06-11-08 3:08
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
Hi all, I have a field of data type text. I have to insert current datetime stamp with the comment 'Automated Notice Sent' in that field. How do I do that? Thanks in advance 
|
| |
|
|
|
|
rawbee
Please log in to subscribe to rawbee's postings.
Posted on 06-11-08 3:15
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
INSERT INTO TABLENAME (FIELDNAME)
VALUES ('Automated Notice Sent @ '+ CONVERT(VARCHAR(10),GETDATE(),101))
Last edited: 11-Jun-08 03:26 PM
|
| |
|
|
U?Me
Please log in to subscribe to U?Me's postings.
Posted on 06-11-08 3:28
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Rawbee, Thanks a bunch:) works like a charm. woohoo !!! YOU ROCKP.S. For others, I needed time stamp too, so I just did CONVERT(VARCHAR(10),GETDATE(),100))
|
| |
|
|
rawbee
Please log in to subscribe to rawbee's postings.
Posted on 06-11-08 3:36
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
COOL.....U R Welcome. U?Me
|
| |
