473,659 Members | 2,836 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

String was not recognized as a Valid Date Time

70 New Member
Hi All,

I Made a window application in c#.net and trying to fetch the record from the postgresql database. But whever i run the application "String was not recognized as a Valid Date Time" message show. This problem is arries from the database when it tries to fetch the record from a table in which timestampz datatype is used. so plz help me to solve this problem.
Feb 8 '07 #1
10 7058
michaelb
534 Recognized Expert Contributor
It would help if you post the table definition and sql query that generates this error.
Feb 8 '07 #2
pankajprakash
70 New Member
It would help if you post the table definition and sql query that generates this error.

Actually there are so many functions and tables in which timstampz is used.

i used following code


IDataReader reader = Rget.ExecuteQue ry("Select * from f_record")

then the error occure. In f_record function timestampz datatype is used.

thanks for reply.
Feb 8 '07 #3
michaelb
534 Recognized Expert Contributor
Can you please run select version() and post result here.
Also, for further debugging it might be useful if you could connect to the database with psql, bypassing the API you're currently using.
Is this option available to you?
Feb 8 '07 #4
pankajprakash
70 New Member
Can you please run select version() and post result here.
Also, for further debugging it might be useful if you could connect to the database with psql, bypassing the API you're currently using.
Is this option available to you?

Actually remoting is used in this application and when i run this application on remote system it truns fine but when i run in my local system this problem is coccurs.
Feb 8 '07 #5
michaelb
534 Recognized Expert Contributor
There's one more thing I'll ask you to do.
Check the Regional Settings on your computer. (Control Panel -> Regional and Language Options)

If they are not set to "English (United States)" set them to it.
(I don't remember if you have to reboot your PC after that)

Then try your query again.
Feb 8 '07 #6
pankajprakash
70 New Member
There's one more thing I'll ask you to do.
Check the Regional Settings on your computer. (Control Panel -> Regional and Language Options)

If they are not set to "English (United States)" set them to it.
(I don't remember if you have to reboot your PC after that)

Then try your query again.

I have already set the region same for both the remote system and my local system. but problem still remain.
Feb 8 '07 #7
michaelb
534 Recognized Expert Contributor
Can we try to summarize the differences between the successful execution and the failure you are having?
Is the successful query originated from the same machine where the database is located?
Is the API you are using (including s/w version if any) the same as on the other machine?
You probably know better all other questions and answers along these lines.

Also, did you ever try to run query select * from tablename
just to take the function out of picture?
Feb 8 '07 #8
pankajprakash
70 New Member
Can we try to summarize the differences between the successful execution and the failure you are having?
Is the successful query originated from the same machine where the database is located?
Is the API you are using (including s/w version if any) the same as on the other machine?
You probably know better all other questions and answers along these lines.

Also, did you ever try to run query select * from tablename
just to take the function out of picture?

Yes the query is running successfully in remote system and also my local system, but when i assing the result to datareader that time error occur.

Yes the API and the s/w version both are same on both system.

The problem still remain.
Feb 9 '07 #9
pankajprakash
70 New Member
Hi michaelb

Finally the poblem has been solved. The problem was in postgresql configuration. The solution is

click on start menu ->Postgresql 8.1->Configuratio n file ->Edit postgresql.conf

then a notepad document will be open
there is
datestyle =
timezone = # actually, defaults to TZ

so change the following

datestyle = 'US'
timezone = MST # actually, defaults to TZ

and then save the document

Thank you very much for you consontration. Really your help was great.

thank you
Feb 9 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2494
by: adolf garlic | last post by:
I'm having a problem with dates. (No not the sort that you have at christmas) I have a webform with a text box and a calendar control. You can either - enter a date manually (we are talking uk style here dd/mm/yyyy) in the textbox - click a date on the calendar which puts the date value in the textbox (uk style)
6
2498
by: Rookie Card | last post by:
I know this is a very common issue but cannot find a thread that resolves the issue. I need to re-format my dates to "MMM d, yyyy". The problem I have is I have an MSSQL database that allows <NULLS>. I'm using this code to format the dates: <%# IIF((dsCase.FieldValue("inj_beg", Container) <> nothing),DateTime.Parse(dsCase.FieldValue("inj_beg", Container)).ToString("MMM d, yyyy"), "") %>
50
4922
by: z. f. | last post by:
HI, i have string in format dd/mm/yyyyy hh:mm:ss and giving this as an input to DateTime.Parse gives a string was not recognized as a valid date time format string error. how do i make the parse method to accept formating that i need. if i do console.writeLine DateTime.Now.ToString it gives the format: YYYY-MM-DD HH:MM:SS TIA, Z.
11
33308
by: Bob Day | last post by:
The IsDate code below should result in False, instead it throws the exception below. Why? How do I check if a string can be converted to a date if this function does not work properly? Bob code: Dim blnDate_Valid As Boolean = True Dim x As String = "Hello"
10
16405
by: dba123 | last post by:
Why am I getting this error for Budget? Error: An exception of type 'System.FormatException' occurred in mscorlib.dll but was not handled in user code Additional information: String was not recognized as a valid Boolean. Public Sub UpdateCustomer_DashboardGraphs(ByVal sender As Object, ByVal e As System.EventArgs)
1
1967
by: pankajprakash | last post by:
Hi All, I Made a window application in c#.net and trying to fetch the record from the postgresql database. But whever i run the application "String was not recognized as a Valid Date Time" message show. This problem is arries from the database when it tries to fetch the record from a table in which timestampz datatype is used. so plz help me to solve this problem.
1
6025
by: Scott Holman | last post by:
I'm connecting to a java web service that defines the following complex type in the wsdl <xs:complexType name="employee"> <xs:sequence> <xs:element minOccurs="0" name="firstName" type="xs:string" /> <xs:element minOccurs="0" name="hireDate" type="xs:date" /> <xs:element minOccurs="0" name="lastName" type="xs:string" /> <xs:element minOccurs="0" name="terminationDate" type="xs:date" /> </xs:sequence>
10
4110
by: mercea | last post by:
hi all, i'm trying to insert the time/date a button was clicked on a gridview and it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. i actually created the date/time column after some data had been entered into the table so the column allows nulls. this is my code: InsertCommand="INSERT INTO...
0
758
by: Andres Bohren | last post by:
Hi i have a GridView and have Problems to put the values into the right Datatypes. Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating Dim intID As Integer = GridView1.DataKeys(e.RowIndex).Value.ToString() Dim strDatum As String = GridView1.Rows(e.RowIndex).Cells(2).Text
3
4971
by: lucindaa | last post by:
Hi, i have a string variable having date as following format "05-01-2010" when convert this date into DateTime Format i got the following error 'String was not recognized as a valid DateTime' Please Help me to solve it
0
8427
marktang
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, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8746
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8525
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
7356
agi2029
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 project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6179
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
1975
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1737
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.