|
by: Shiperton Henethe |
last post by:
Hi
Know any good utilities to help me strip out the tags that
Microsoft Excel 2002 leaved behind when you try
and export an HTML format file?
This is driving me NUTS.
And really makes me hate microsoft with a passion.
I literally just want "compact HTML" - ie just the data,
|
by: yasaswi |
last post by:
I have date values in mm/dd/yy format in a text file. How can use the
LOAD command or mysqlimport command and load those date values.
Currently I just load the date values as text into MySQL tables and
manipulate the text in applications. There must be a better way? can I
use DATE_FORMAT or something like that?
Thanks,
Yasaswi
|
by: Kevin Thomas |
last post by:
Hello,
I have a date value in a table SQL Server database that looks like this:
2005-10-11 12:54:36.860
When I load the record into a dataset in VB.NET and retrieve the date value
into code, what I get is:
#10/11/2005 12:54:36 PM#
It has chopped off the milliseconds. How do I get the full date and time
|
by: Stefan Bauer |
last post by:
Hi NG,
we've got a very urgent problem... :(
We are importing data with the LOAD utility. The input DATE field data
is in the format DDMMYYYY (for days) and MMYYYY (for months).
The target data format is european DD.MM.YYYY (for days) and
01.MM.YYYY (for months).
The input format is not recognizable as a DATE input to a DB2 LOAD for
|
by: Jean-Marc Blaise |
last post by:
Dear all,
I have a table that contains a DATE in char(10) format. This table is
LOADed.
I put a check constraint on the column, some kind of CHECK (DATE(F) <=
DATE('9999-12-31'))
and I would like to move badly formatted field to the exception table.
The problem is I will always get SQL0180N and the record is not moved into
|
|
by: Shapper |
last post by:
Hello,
I created a dataset from a XML file. One of the dataset fields is
.
In an ASP:Repeater I am displaying the field.
<%# DataBinder.Eval(Container.DataItem, "pubDate", "{0:f}") %>
The date displayed has the following format, the same as in the XML
file:
|
by: mrabinovich |
last post by:
Hello,
I have Julian date in format YYDDD in the load file.
A column in the table to be loaded has regular date format.
I am using IBM load utility. How can I convert data?
(In JCL before Load I can put some logic to modify Julian date field to
YYYYDDD)
Thank you very much.
Mike
|
by: Jim in Arizona |
last post by:
I have a gridview that's being populated from an access db query. The
problem I'm having is that the date/time fields in access that are
populating the gridview are showing both date and time, when the field
should only be showing one or the other (date or time).
Even on the back end of the database where the column properties are, I
have chosen the smallest date/time formats. When the aspx page runs, it
shows the date and time (ie:in a...
|
by: huyuhui |
last post by:
The following is a question of LOAD utility.
Question:
How does the DB2 enforce table check constraints for data added to
table with the LOAD utility?
A. With the BUILD phase of LOAD
B. With the SET INTEGRITY statement
C. With the DELETE phase of the LOAD
D. With the UPDATE CONSTRAINTS statement
Answer is A
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|