English 中文(简体)
进口日期从前列车或进入航天飞机?
原标题:Importing dates from excel or access to SQL Developer?

我有一个日期领域,我正试图将这个日期输入到Skker公司,但我或是收到关于格式的错误信息,或是其日期值来自外部。 是否有任何人知道如何从Excel进口日期,或进入QQS开发商? 感谢。

问题回答

Excel stores date in a different way. You can change format in sql developer Tools >Preferences >Database->NLS I think you can change the format to "DD-MON-RR HH.MI.SS" depending on your requirement. http://www.jasonsdevelopercorner.com/?p=209





相关问题
Mysql compaire two dates from datetime?

I was try to measure what is faster and what should be the best way to compare two dates, from datetime record in MySql db. There are several approaches how to grab a date from date time, but I was ...

iPhone Date Picker rolls over to 2010 on December 27th?

So I implemented a UIDatepicker in one of my applications for scheduling and autodialing teleconferences... everything is pretty much ready to go except, while testing I noticed that when the date ...

Convert date Python

I have MMDDYY dates, i.e. today is 111609 How do I convert this to 11/16/2009, in Python?

specifying date format when using $form->inputs() in CakePHP

I am wondering if there is a way to specify the date format in the forms created using CakePHP s $form->inputs(); Please note that this is not the individual $form->input() but instead $form->inputs() ...

NSDateFormat, super simple! Where am I screwing up?

Ok, this is really simple, maybe I m a getting a bit burnt out, but seems like it should work, Query XML feed, put out date string, format, display in a cell. The issue is I m a getting a NULL ...

sqlite writing a date into an email

I am exporting a date value from sqlite and placing it into an email. The date appears like this 279498721.322872 I am using Objective C in an Iphone App. Does anyone know how to make this export ...

热门标签