Tips for Using Time Stamps in ILE RPG

I think you are asking for the negative value with the largest magnitude? Well, java double primitive data type (not to be confused with Double object type) is a *signed* 64-bit floating point value. The first bit is a sign bit. Therefore, the largest negative value (in absolute magnitude) is:
-Double.MAX_VALUE

Yes, that’s right. You just put a negative sign in front of it. 🙂

It’s dreaded timestamp in SQL server. Though the name says it is timestamp, it’s really not. So don’t do a read/write on that column. It’s a kind of rowid precisely. By definition from SQL server books:
”
The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.

It further states Never use timestamp columns in keys, especially primary keys, because the timestamp value changes every time the row is modified.
”
Hope it helps.

Do you mean Abstract Data Types or Data Structures? I shall endeavor to provide answers to both questions.

Data structures:
A data stucture is a way of structuring data so that your chosen algorithm can process the data in an efficient manner, i.e., in such a way as to utilize as little storage space and execution time as possible. There are myriad ways to structure data, however, the most common method by far is the ubiquitous array. Data structures ranging from the simple to the complex are based on the node. A node is simply a collection of two sections of memory. One section of memory stores the data. The second section stores a location to another node in memory. If there isn’t another node then the node stores a NULL (nothing essentially).

Abstract Data Types:
Computers do not natively know how to deal with numbers. *GASP* “Blasphemy,” you say! “Computers don’t know nothing BUT numbers!” nuh uh uh… computers don’t know anything. All a computer does is deal with on and off switches, essentially. Therefore, the programmer and CPU designer must tell the computer how to deal with numbers. Integers, the set of all real numbers — i.e., -3,-2,-1,0,1,2,3, are infinite. A computer is finite. I can’t go into how a computer deals with integers exactly. I could get into the binary representation but I have a feeling that you wouldn’t know what I was talking about.

Programmers need data types that the compiler does not offer. The compiler offers integers, floating point, characters, strings, etc. But what if the programmer wanted a data type that dealt with coordinates? He/She would simply define a class or a struct that contained data and methods to act upon and maintain that data.

Since timestamps are expressed in seconds, calculate the difference and then divide it by 60. Something like this should work:

< ?php function time_diff($timestamp) { return floor(abs(time() - strtotime($timestamp)) / 60); } $event_date = "2011-02-05 01:45:50"; echo time_diff($event_date); ?>

I used floor so that if the difference is, for instance, 59 seconds, the function will return 0 (it is not a whole minute). If you want to round up the minute value, replace floor() with ceil().

Lols, if you want a more slapstick comedy to him, you can always make him a pervert expert in girls “three” sizes or something like that haha! That would be comedy fun for guys *winks*

If you want him to has at least ONE redeeming qualities about him in a more RL POV, you could make his expertise be something rather noble or respectable, like a good detective investigator (too cliched these days?) Or someone who is good at telling who a person really is by looking at one quality of a person’s body, like, ie, looking at one’s fingernails, hairstyle, or feet, or something! Just something eccentrically weirdly random! 😀

That would go well with his aloof comedious hilarious type of character!

😀

Hi –

It all depends on how you send the date to Oracle from VB.

If you want to use the sysdate, and you always want to use the sysdate as the timestamp when inserting a record, then it is best to make the column in your Oracle table have a DEFAULT value of sysdate and not pass the date to Oracle when inserting the record. By default, if no value is passed to the date field, then on insert it’ll grab the sysdate by default and you don’t have to worry about it.

As an example, say you have table TEST with 3 columns:

SQL> create table test (x number, y timestamp default sysdate, z varchar2(12));
Table created.

SQL> insert into test (x,z) values (1,’hello’);
1 row created.

SQL> commit;
Commit complete.

SQL> select * from test;

X Y Z
———- ——————————————— ————
1 12-MAR-08 09.09.18.000000 PM hello

Or you can explicitly enter sysdate as a value:

SQL> insert into test (x,y,z) values (1,sysdate,’hello again’);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

X Y Z
———- ———————————————— ————
1 12-MAR-08 09.09.18.000000 PM hello
1 12-MAR-08 09.12.13.000000 PM hello again

Nothing wrong with the trigger you made. What is causing your problem is the insert statement.

Several things needs to be considered in an insert statment.
1. You need to make sure all NOT NULL columns is included in your insert statement

2. If your not specifying the columns in the insert statement, make sure that the values clause contain ALL the columns in the table and in the correct order.

3. You can also specify the columns which the insert statement will populate. In your example, insert into emp(col1, col2, col3, col4) values (10, ‘Adam’, 50000, ‘MIS’); Only col1, col2, col3, coll4 will have values and the other columns will have a value of null.