Home Posts Topics Members FAQ
Shishir
The sql
select TIMESTAMPDIFF(1 ,CHAR(TIMESTAMP ('2001-09-29-11.25.42.483219 ') -
TIMESTAMP('2001-09-26-12.07.58.065497 '))) from sysibm.sysdummy 1
works in db2 8.1.2/RHEL 2.1
but gives the error
DB2 SQL error: SQLCODE: -443, SQLSTATE: 38552, SQLERRMC:
SYSFUN.TIMESTAM PDIFF;TIMESTAMP DIFF;SYSFUN:03
on db2 8.2/RHEL 3
Any pointers?
Regards
Shishir
Nov 12 '05 #1
Subscribe Reply
1 12111
Jan M. Nelken
Shishir wrote:
The sql
select TIMESTAMPDIFF(1 ,CHAR(TIMESTAMP ('2001-09-29-11.25.42.483219 ') -
TIMESTAMP('2001-09-26-12.07.58.065497 '))) from sysibm.sysdummy 1
works in db2 8.1.2/RHEL 2.1
but gives the error
DB2 SQL error: SQLCODE: -443, SQLSTATE: 38552, SQLERRMC:
SYSFUN.TIMESTAM PDIFF;TIMESTAMP DIFF;SYSFUN:03
on db2 8.2/RHEL 3Any pointers?
Regards
Shishir
Function TIMESTAMPDIFF returns an INTEGER (signed INTEGER) representing number
of units (units selected by value of first argument) in the Timestamp Duration
represented by second argument.
In your case first argument is 1 - which represents microseconds, second
argument is timestamp duration of 2231744.417722 seconds.
Convertion of this duration to microseconds and storing result into an INTEGER
is impossible.
Jan M. Nelken
Nov 12 '05 #2
This thread has been closed and replies have been disabled. Please start a new discussion.
Similar topics
1 1812 Having problems with displaying date by: paul |last post by: Hi everyone, I'm having problems displaying a date in the correct format and I was wondering if anyone knew how to help. I'm using pear to extract a date from our back end database (the date is in DATE_FORMAT_ISO_EXTENDED), and I was to display the date in "Wednesday, February 23rd 2005, 11:04" format. I'm using something like: PHP |
2409 Having problems running query in Oracle by: George |last post by: I have two tables and want to find the Maximum date for a given GIN. I have been able to produce the result in Sybase but I am having problems in Oracle. Example of my query in Sybase. create table #temp1 ( groupcode char(10), loc_acc_no int, gin int, Oracle Database |
8 1711 Still Having Problems with VS.NET 2003 by: Michael C |last post by: Hi all, I'm still having problems with VS.NET 2003 running on my XP machine. I finally decided I might as well uninstall completely and reinstall from scratch. But lo and behold it won't let me uninstall... It gets stuck about 2/3rds of the way through the uninstall (based on the progress bar) and hangs for a very, very long time (a few... C# / C Sharp |
4 1605 Still having problems with session state by: Charles |last post by: I am still having problems with sessions crossing over from other sessions. What I mean by this is that Mary may get just some or all of Renaeâs information. I think that what is going on with this problem is the way that I have the solution setup I have this .NET CEmployees class that I am storing into a session object. The sessions are... ASP.NET |
11 1477 Servers having problems? by: Rick Mogstad |last post by: I know this is probably not the group for this, but i know that these groups are fairly active, and that the people are usually willing to help. Is anyone else experiencing this? The news server is responding VERY SLOW for me. it takes about 10 minutes to download 150 text messages. All other news servers are working fine for me, its... Visual Basic .NET |
7 1794 Is the server having problems, or am I? by: Ron |last post by: Hi All, It's taking a long, LONG time for me to see a post from here (and other NGs too, for that matter--which is why I think it may be me...). Sometimes it takes 2-3 minutes after clicking the post for me to be able to read it. And sometimes, it never comes up..instead I get "Message is no longer available on the server". Also, like... Microsoft Access / VBA |
2 1729 Having problems with vectors! by: l46kok |last post by: Hello. This is the first time I'm encountering vectors and I'm having problems. I want to create a vector filled with objects, but as soon as I try to invoke a function within the object, I get an error message stating "Vector out of subscript range". And I'm using C / C++ |
1 2770 IE7 having problems with regular expressions by: tshad |last post by: Some of my regular expressions don't seem to work correctly in IE7. I am on asp.net 1.1. I have a site that has been up for a while and I started having problems on machines with IE7. IE5 and IE6 seem to work fine. In the following - 919-111-2222 as well as (919)111-2222 was giving one of my clients the error message and IsValidate was... ASP.NET |
3 1591 Having problems with urlparser concatenation by: i80and |last post by: I'm working on a basic web spider, and I'm having problems with the urlparser. This is the effected function: ------------------------------ def FindLinks(Website): WebsiteLen = len(Website)+1 CurrentLink = '' i = 0 SpliceStart = 0 SpliceEnd = 0 Python |
4 2094 having problems getting mysqli installed on PHP 5.2.1 by: chris |last post by: Hello all, I am having problems getting Apache 2.2.4 to read the php_mysqli.dll file some my C:\php\ext\ directory. The following is the error that Apache displays in the error log: PHP Warning: PHP Startup: Unable to load dynamic library 'C:/php/ext/ php_mysqli.dll' - The specified procedure could not be found.\r\n in Unknown on line 0... PHP |
7703
What is ONU? by: marktang |last post by: ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main... General |
7931
Problem With Comparison Operator <=> in G++ by: Oralloy |last post by: Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ... C / C++ |
1 7682 The easy way to turn off automatic updates for Windows 10/11 by: Hystou |last post by: Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For... Windows Server |
7984
Discussion: How does Zigbee compare with other wireless protocols in smart home applications? by: tracyyun |last post by: Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the... General |
6290
AI Job Threat for Devs by: agi2029 |last post by: Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then... Career Advice |
3663 Trying to create a lan-to-lan vpn between two differents networks by: TSSRALBI |last post by: Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in... Networking - Hardware / Configuration |
3655 Windows Forms - .Net 8.0 by: adsilva |last post by: A Windows Forms form does not have the event Unload, like VB6. What one acts like? Visual Basic .NET |
1 2119 transfer the data from one system to another through ip address by: 6302768590 |last post by: Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system C# / C Sharp |
1 1230
How to add payments to a PHP MySQL app. by: muto222 |last post by: How can i add a mobile payment intergratation into php mysql website. PHP |
By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.
To disable or enable advertisem*nts and analytics tracking please visit the page.