Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^5: Code flow not going to while loop

by chacham (Prior)
on Aug 02, 2017 at 21:09 UTC ( [id://1196593]=note: print w/replies, xml ) Need Help??


in reply to Re^4: Code flow not going to while loop
in thread Code flow not going to while loop

Hmm... Maybe the client on your test server is supplying a default that the code is not. Let's take a look at TIMESTAMP.

A string of length 14 that is a string of digits that represents a valid date and time in the form yyyyxxddhhmmss, where yyyy is the year, xx is the month, dd is the day, hh is the hour, mm is the minute, and ss is the seconds.

You could provide that if you remove the spaces and colons.

If the arguments include only date information, the time information in the result value is all zeros.

I do not know if your code demands it, but all your times are zeroes. Meaning, you could just as well remove the time part and TIMESTAMP() will return the same result.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1196593]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2024-03-28 11:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found