Question:
Hi everybody.
I have an application that send emails to subscribers every week, every 14 days and every month, I select this information using an sql script every day.
Now i need to implement the two months subscription.
I like to make an sql select that retrieves this information and send the newsletter (for months with more than [...]
Question:
Hello, I have my g/f grandmothers Rca Web Tv System. RCA model Number RM2100. What do I need… The girlfriends grandmother can no longer live on her own so she has to move into a old folks home. they do not have a private phone line in there but they have wireless internet. The RCA [...]
Question:
How to get the yeterday’s date base on the sysdate using shell programming
Solution:
Here’s the testing result from my box:
SunOS mybox 5.8 Generic_117350-47 sun4u sparc SUNW,Ultra-250
# TodaysDate=`date +%Y%m%d`
# Yesterdaydate=`TZ=$TZ+24 date +%Y%m%d`
# echo “Today: $TodaysDate”
Today: 20071004
# echo “Yesterday: $Yesterdaydate”
Yesterday: 20071003
Could you please type in:
echo $TZ
see what you get?
Question:
I am parsing out HTML from another page, that includes a date and time . I need to store this date/time in a MySQL database. I successfully constructed a string that has the timestamp in it. The string right now is set to “02/16/2010 12:51:47″ . When I try to insert this string into MySQL, [...]
Question:
I’m sure this issue is discussed somewhere, but I’m not finding it, so sorry in advance if I seem a little dense (maybe I need some sleep I’m writing some Java code to display time. Whenever the time is something like 23:00, it only shows 23:0; with 23:01, it only shows 23:1. Must [...]
Question:
Hi yah I am using SQL Server 2008 Enterprise and Visual Studio 2008
I have a Table in SQL Called Personal
With the following in it
CREATE TABLE [Personal]
(
[PID] int IDENTITY (1001, 1) NOT NULL PRIMARY KEY,
[FirstName] varchar(20) NOT NULL,
[MiddleName] varchar(20),
[LastName] varchar(20) NOT NULL,
[DoB] date NOT NULL,
[Gender] varchar(7) NOT NULL,
UNIQUE (PID)
)
INSERT INTO Personal VALUES(‘Abhisek’, ‘Chandrashekhar’, ‘Kadam’, ‘02/27/2002′, ‘Male’)
…and [...]
Question:
Hi,
i’ve been using the below batch file code for years now to display the correct date regardless of the regional settings and also calculate from that the correct day number which refers to a day name. However, since 2010 (I think) it’s been calculating the day number incorrectly and therefore the dayname. The part of [...]
Question:
Greetings Experts,
I am trying to get a combo box named ‘YearBox’ on a form to pass the year to a query. The source of the combo box is a table with just three records, 2008, 2009, 2010. I want the year I select from the drop down list to pass to a query that has [...]
Question:
I have a machine that runs Windows XP SP3. The user of the machine logs in as a restricted user. The user must remain restricted – this cannot change.
When the user double-clicks the clock in the system tray, the following message appears: “you do not have the proper privilege level to change the system time” [...]
Question:
compute duration Time of last data modification or creation
for my exe file and current date time
how can i do that ?
please code it
i tried to use _fstat to get st_ctime and get time_t
but it not run may be i mistake to use it please help me thanks
Solution:
See this:
It checks for last modify time of a [...]