What is the best way to retrieve the date and time from an online server instead of retrieving from the user PC? Some sample codes I found online can only request to a server which is window based which I can't find any free server to get. I thought of retrieving the value from a website like [URL] but I'm not sure is this feasible or not as their website content or html tag might change.
View 3 RepliesThought I'd see if Stack overflow is quicker than me testing something while I get a thousand interruptions from other work :)
I'm updating an old VB net application and trying to refactor some of the logic as I go. The app looks for data from a single date across a few tables and writes that view to a file.
Writing the query in SQL I'd get the equivalent of
SELECT * FROM table
WHERE CAST(FLOOR(CAST(table.date AS float))AS datetime) = '15-Jul-2010'
Ideally I'd use
SELECT * FROM table WHERE date=@input
and add a date object as a parameter to a System.Data.SqlClient.SqlCommand instance
Are those two comparable? Will I get the results I expect?
I am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
Title pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 RepliesI have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
How do I turn this:
20101028094024.500000+060
into a readable date and time.
I want to get the date in a date and time picker and convert it to check if a row in my database is either < or > than a than a DepDate field in my database.The SQLServer field type is Date... HOw can I do this?
View 6 RepliesI have a Date variable called Time1In.
I'm getting a time value as a string from Excel, so I assign the date variable a value like this:
the string value coming in from excel is this:
30/12/1899 7:40:00 AM
my code gets the time value and assigns it to the date variable:
TimeIn1 = TimeValue(strTimeIn1)
the Date variables value is then this:
#7:40:00 AM#
which inserted into my database datetime field then looks like this:
0001-01-01 7:40:00
That causes errors when loading the page. I need to set a date value on the date variable. How can I properly append a date to the variable?
Ok i got the time and date in 2 datetimepickers called TimePicker and DatePicker.I want so when you click a button it will start counting down to that date and time. I dont know where to start can anyone give me some guidance. Or example code would be great.
View 10 Repliesif the current hour is less than 21:00 (today) then show the remaining time in label3 as hh:mm:ss remaining. However, if the current hour is greater than 21:0
View 6 RepliesI know a Date time picker is dropdown activated but is it possible to have just the calander poping out, or should I start programining my own calander?
View 2 Repliesis it possible to get the correct time online? Because we are currently making a system that requires date and time. We are preventing a common error where the system time is outdated so we are going for online time and checking it in out system.
View 2 RepliesI have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? Is it curdate and curtime?
View 9 Replieshow to get the time difference between 2 date & times Where
from_time falls >= 22:00 of the From_date & the to_time falls <= 06 of the To_Date
for example:
From_Date = 01/01/2011 20:00 ' Where Work Started
To_Date = 02/01/2011 08:00 'Where Work Ended
Time_Covered_Between_22TO06_As_Night = 22:00 to 06:00 is 08:00 hrs How to equate it?
adding basically just the current date and time to a textbox/label or something like that? I have looked at coding but everyone seems to do it in such a complex way. Is there not a simple way of doing this? I don't want to use the date time picker as I don't want a user to be able to select the date or time.
View 4 RepliesI am using VB 2008 and have a datetime picker. I am trying to use this value in an INSERT command to load in to a table but I just can't get it to work. I have changed the date format of the datetimepicker to dd/mm/yyyy . when i m trying to insert it in sql server, type conversion error arises...
View 2 Replieshow do i display the time and date using a label? I have the time displayed in a timer tick like this : label7.text = timeofday() But i cant seem to get both time and date up
View 5 RepliesHow can I make the value of the DTP to be 19/03/2010 0:00:01am instead of 19/03/2010 3:57:29pm
View 2 RepliesI'm importing data from an excel file. They have a date column like 06/07/2011 and a time1in column with a value like 13:00:00. Now I convert the datestring to a date like this:
[Code]....
I'm working on a small accounting app. I have a query to show transactions with a running balance.
SELECT transactionid, transactiondatetime,
amount,
(SELECT SUM(amount)
FROM dbo.transactions as D1
WHERE D1.transactiondatetime <= D0.transactiondatetime) AS balance
FROM dbo.transactions AS D0
I capture a gamesheet for a certain week. so if I select a date on a monthcalendar the sheet applies to the weeknumber of the selected date. When I save transactions I take the date at the last day of that week as the transactiondate. I need to store a datetime though because my query works of the datetime to get an accurate running balance. How can I append now() time part to my date variable and then store that in a datetime variable to get a transactiondatetime.
Here is my code for getting a transactiondate:
Dim dt As New Date
dt = Me.MonthCalendar1.SelectionStart
'get last date of week. Friday
Dim tdate As Date = dt.AddDays(5 - CInt(dt.DayOfWeek))
Im trying to Assign the date to a text box without the time, using a button. i also want to be able to use the text box to enter a alternate date. i have found some basic..Basically i am making a form for personal use to help me do my paper work..[code]
View 10 RepliesI'm using VB.net 2003 Standard Edition, and I'm trying to retrieve the file modified date. I've created a System.IO.FileInfo object, and have collected info from the three methods: CreationTime, LastAccessTime, and LastWriteTime, but they aren't giving me the same data as XP Windows Explorer is.In Explorer, there is a Date Modified field (currently reading 2008 on the file in question), but using the FileInfo methods they return 2007, 2009, 2009.Is there another IO object I can use to get this 'modified' date?
View 1 Repliesi have return the follwoing to retrieving server date
Private Structure TIME_OF_DAY_INFO
Dim tod_elapsedt As Long
Dim tod_msecs As Long
Dim tod_hours As Long
[code]....
im getting error "arithematic operation resulted in an overflow
I have a database table that stores a datetime value.I want to display that value on my asp.net textboxes, except I need to show date value in TextBox A and Time in TextBox B.How can I split those values in VB.NET?
View 2 RepliesI am trying to format the day, date, and time to look like something like this "Thu,
[Code]...
I'm looking for a way to convert a 5 character time representation to a date object. ie. "0937a" should be "6/16/2010 9:37 AM" or "1215p" should be "6/16/2010 12:15 PM".
View 2 RepliesThis is my code for displaying data, but there's always the TIME on my date column
[Code]...
I need to display on my datagridview the data from MYSQL db, but I'm having a problem on a field which is in DATE format in mysql
cmd.CommandText = "SELECT * FROM tbl_user_log"
cmd.Connection = sqlcon
dr = cmd.ExecuteReader
[code].....
New to VB.NET Programming. Im trying to set the dates pickable on a Date Time Picker to the current day and onwards, i do not want someone to be able to chose DateToBeShipped to yesterday for example.
View 7 RepliesI am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet