U?Me
Replies to this thread:
More by U?Me
What people are reading
Subscribers
Please log in to subscribe to U?Me's postings.
:: Subscribe
|
[VIEWED 2665
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
|
|
Please Log in! to be able to reply! If you don't have a login, please register here.
YOU CAN ALSO
IN ORDER TO POST!
Within last 365 days
Recommended Popular Threads |
Controvertial Threads |
TPS Re-registration case still pending .. |
TPS Re-registration |
What are your first memories of when Nepal Television Began? |
निगुरो थाहा छ ?? |
ChatSansar.com Naya Nepal Chat |
Basnet or Basnyat ?? |
Sajha has turned into MAGATs nest |
NRN card pros and cons? |
Toilet paper or water? |
TPS EAD auto extended to June 2025 or just TPS? |
Do nepalese really need TPS? |
Biden out, Trump next president, so what’s gonna happen to TPS, termination? |
कता जादै छ नेपाली समाज ?? |
मन भित्र को पत्रै पत्र! |
Will MAGA really start shooting people? |
Democrats are so sure Trump will win |
Anybody gotten the TPS EAD extension alert notice (i797) thing? online or via post? |
Tourist Visa - Seeking Suggestions and Guidance |
Top 10 Anti-vaxxers Who Got Owned by COVID |
I regret not marrying a girl at least for green card. do you think TPS will remain for a long time? |
|
Nas and The Bokas: Coming to a Night Club near you |
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year. |
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks |
TPS Update : Jajarkot earthquake |
|
NOTE: The opinions
here represent the opinions of the individual posters, and not of Sajha.com.
It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address
if you want any posting to be considered for deletion. Your request will be
handled on a one to one basis. Sajha.com is a service please don't abuse it.
- Thanks.
|