Im using a MySQL Server and id like to know the date and time that its running...Here's the query:
SELECT GetDate
But im getting an error saying there's no such field in the database.Everything is fine i know how to connect im just bored writing the code here....Do i have to Execute the query or read it?Im using a Reader...
I 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:
I have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd") 'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
I am making a Punch card system for the company, so employees can punch in and out from their computers.i cannot get the date and time from the client computer because they can change the date and time. So I will need to get the date from our SQL server.
I have a datetime field in a SQL Server 2005 table that has values like this:2012-04-23 09:00:00.0002012-04-23 14:00:00.000The minutes, seconds, and microseconds are always zero.I need to display a "time slot" (basically, the time plus one hour) like this:
2012/04/23 09:00 AM - 10:00 AM 2012/04/23 02:00 PM - 03:00 PM
I have a program in vb.net and with it I have an expiration Key. As an example I would like this key to be valid for 3 months .I don't want to use the users system.date in case the user changes the date.Could a public server's date time be used instead.
I'm trying to create an auction site using asp.net. My auction's start date & time and end date & time are stored in my sql server 2008 r2 database as datetime types. I'm using vb.net. I'm trying to create a select statement in which I can query the date and time portion relative to the current date and time (so as to only display current ongoing auctions). I can successfully query the date portion using the Date.Now function, but the time is giving me a hassle. DateAndTime.Now doesn't work. I've even tried to separate the time and date in the database, but I still can't get an effective query. Here are two examples of code which I've tried:
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?
I have this situation where I have a SqlDatasource control and the select query is like:
SELECT col1, col2 FROM table1 WHERE colDate = @date
The source of @date is a label with the text: 2009-05-29 12:06:00 I get the following error when I run the query:
Conversion failed when converting date and/or time from character string
I tried using convert(datetime, @date), as well as different date/time formatting of the label itself. Everytime I get the error.
However, when I run the query in the management studio like:
SELECT col1, col2 FROM table1 WHERE colDate = '2009-05-29 12:06:00'
I found out that the @date is parsed as 05-29-2009 01:30:00 TT I don't know where the TT is coming from? And I'm sure SQL Server wouldn't be able to handle it?
Thought 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
I 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?
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
i am using date time picker and i am selecting 1 date from calender.after selection of that date i want to refresh date time picker i.e. it should display todays date.
to trace the days of a program installed in user's computer.However, the user can changes the system time of his computer to a advancing date. How can I get a SNTP time from internet to solve this problem?
The problem that I'm having is that when I try to select a different date, the text doesn't go away. That may make no sence, but let me tell y'all what I've done.
1: Created a GroupBox 2: Put a DateTimePicker in the GroupBox 3: Put TextBoxs in the GroupBox 4: Changed the DateTimePicker to look like this: A)Checked - False B)Allow Drop - True
I thought that if I changed that, then the text in the text box would go to that specific date. It didn't do that, it just stays the same. What I'm trying to do is enter text in say 3/7/11 and when I choose date 6/12/12 it will display blank text boxes for me to enter something different.
I have a datetime picker in one of our apps. When loading up the win form I need the date time picker to default to the Wednesday following todays date. Any idea how to do this? We are using .Net 1.1 for this app.
I have a program that reads a file with Pacific Daylight Time, I want users to see the time and date in their local environment.
At present I have in Australia a time difference of 18 hours, so I have a list box with -24 to +24 and currently set at 18, my code is elementary as long as I have moved past day one of the month it suits me personally, but I want to distribute my app, so I need something better.
The Now() function in VB.NET returns date and time which is different from the system time that I see on the right-bottom on the notification bar. It is 15 hours slower than the system time. Has anyone ever met this problem? I'm using .NET 2.0.