date/time or date and time
I am setting up an SQL database and I will need to get differences in dates. For example I have a start date, start time, completion date and completion time and I want to get the difference between the start and completion.
Would it be better to have one field with both date and time in it, or better to have a date field and a time field?
Even though I have already started setting up the tables with seperate fields for date and time I am now leaning toward one field with date/time in it. (Only because that is the way I had to do it when setting up an Excel spreadsheet for a similar ta...Daylight Savings Time and File Date/Time Stamps
We use automated scripts for AutoCAD Lisp routines to compare files on a
local workstation's hard drive to the same files located on the server.
If the server files are "newer", then we copy them to the workstation.
Thus... we have a poor man's setup to "update" workstations when AutoCAD
Lisp programming changes/updates are made.
When Daylight Savings time ended Saturday night, the server's time changed
as expected, but the time stamp on our files created between April and
October also changed. All the files created in that time period had a o...Powerbuilder and Time
I am running Powerbuilder 8. My application has the
following code, that determines if the time is 2:15. How do
you read this? I need to change the time to 2:30.
//Don't allow the user to change cash data after 2:15 pm
ldt_date = f_getdate()
ll_seconds = 51300 - ( (Hour(Time(ldt_date))) * 3600 +
Minute(Time(ldt_date)) * 60)
change the 51300 value to 52200.
The 51300 represents the number of seconds since 12:00am which would
correspond to 2:15pm
51300/ 60 seconds in a minute / 60 minutes in an hour = 14.25 hours since
12:00am or (2:15pm)
52200/ 60 seconds in a mi...java date time and utc date time
i have a client written in delphi
the backend is written in java (webservice)
when fetching a date field from the db, through java to delphi (TXSDateTime class), for some reason the date changes.
in the db: 30/07/2009 00:00:00
in delphi: xsdatetime.asdatetime = 29/07/2009 23:00:00 (1 hour before)
in delphi xsdatetime.asutcdatetime = 29/07/2009 21:00:00 (3 hours before)
i guess it's a matter of timezones but all we want is simply to fetch the same date as it appears in the DB
what are we missing?
amos szust wrote:
> i have a client written in d...times out all the time!!!
Name: Optical Excellence
Summary: times out all the time!!!
I can not access either the web email site downloaded mail nor the
Thunderbird email downloaded email because I get a time out all the
time!! Not a way to run an email site, especially as this is for our
Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:22.214.171.124) Gecko/20070725 Firefox/126.96.36.199
Delphi 2010 with PostGresSQL 9.3 database.
I did try := Time(), the way it worked with Paradox and many more I tried.
E2250 no overload version of "TimeToStr" that can be called with this
Can somebody guide me here, thanks in advance.
dm.tArrivedwaiting.value := timetostr() - dm.tArrivedtime.value ;
Fields are StringFields or time with time zone(tried without??)
CREATE TABLE "ARRIVED"
dummy serial NOT NULL,
"time" time with time zone,
...MOVED: time between to given times (was: time between to given times)
On Wed, 11 Feb 2009 15:21:06 -0800, Mike Thomas wrote:
Moved to delphi.language.delphi.general
Marc Rohloff [TeamB]
marc -at- marc rohloff -dot- com
...ODBC / Profile Creation From Run-Time PowerBuilder
17 September, 1999
ODBC / Profiles can be created at design time in PowerBuilder. But is there
any way / functions by which it will create ODBC profile?
Program at run-time will check existance of ODBC DSN. If not found it should
call the function with path of database & other information to create the
Dipesh Panchal wrote:
> 17 September, 1999
> ODBC / Profiles can be created at design time in PowerBuilder. But is there
> any way / functions by which it will create ODBC profile?
> Program at run-time will ch...How to get date/time stamp on email header?
We're using GW 6.5.1 on a novell 6.5 server. Clients are running WIN XP fully patched. We are not getting a date/time stamp on the header of emails when they print.
1) Is this by design?
2) If so, (WHY?) is there a way around it (perhaps third party)
3) Which third party?
> We're using GW 6.5.1 on a novell 6.5 server. Clients are running WIN XP
fully patched. We are not getting a date/time stamp on the header of
emails when they print.
> 1) Is this by design?
> 2) If so, (WHY?) is there a way around it (perhaps third party)
&...I am having hard time to setup the classified at godaddy keep getting run time error
Hi I download the classified starter kit and uploaded it to godaddy but I still can't get it to work1-I created 2 database , one for classified and the other for the users.I I keep getting run time error even talking with godaddy did not help. <!-- Web.Config Configuration File --><configuration> <system.web> <customErrors mode="Off"/> </system.web></configuration>
Notes: The current error page
you are seeing can be replaced by a custom error page by modifying the
"defaultRedirect" attribu...it's running on design time but not run time.
Code is like that. This code is running on desing time.. but it is not running on run time. Exception is "ComException:An operations error occured."
After "search.findOne(); " exception occured. Probably reason is security.. but What's wrong? Thanks for advice.
--------------------------------------------------------------------------------------------------------------System.Security.Principal.WindowsImpersonationContext impersonationContext = ((System.Security.Principal.WindowsIdentity)Page.User.Identity).Impersonate();
Session["UserName...just Time or date portion of a date/time field
From a DateTime data column how do I get just a
Time portin or just a date portion of data to be displayed.
11/6/2003 10:03:20 AM
I need to display date and time seperately in my data display page.
In code you could use
Dim dt as System.Date
Dim day, month, year as integer
day = dt.Day
year = dt.Year
This also works with DateTime
In SQL you could use
where <datepart> is the abbreviations mentioned in post 385301 and <datetime> is a...Getting time between 2 other times
Im making a app (vb) for work. i need it to basically countdown the hours and minutes until 4:30 pm thats when we get off work so if the current time is 3:00 PM then the app will spit out 1 hour 30 minutes. I have been playing around with the datetime but cant get it to work. I currently have a timer on the app and is giving the current time and UTC time that is realtime. Thanks
I hope this converted (from C# to VB) OK:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
' qutting time is six thirty PM
Dim QuittingTime As TimeSpan = ...Removing Time from date time
We would like to form a recordset that would have the datetime column be
just the date. We have students visiting our web several times a day and
each of these are counted as distinct dates. We would like just the
total number of days that they used the web not the total number of
times they accessed the web.
You can use date function on datetime column, or use cast. eg:
select datetime_col, date(datetime_col), cast(datetime_col as date) from
Hope this helps,
jmwarren wrote in message <39A66A36.8B355AA6@pilot.msu.edu>...
>We would li...