Gail
Posts: 0
Joined: Tue Mar 06, 2012 12:34 am

How to change the data type of a database column?

Oops! I mean I would like the database column to be of data TYPE date..

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

How to change the data type of a database column?

You could set some fixed date and only change the time.

RobertJay
Posts: 0
Joined: Fri Jun 15, 2012 1:32 pm

How to change the data type of a database column?

Hi, I'm having difficulty importing the field "lat_lon" to be a geopoint field as shown below. I've tried various alternatives to "name:geopoint","lat_lon" - with no success. Can you tell me what I should be using in the first row. The csv data source is Excel. Thanks.

http://screencast.com/t/k9S9iSR5mgX

Igor
Posts: 0
Joined: Tue Apr 02, 2013 12:05 pm

How to change the data type of a database column?

Hi,

Your CSV file has incorrect field description. You can create simple collection and export it to the CSV file to get the correct file format.
An example CSV file:
pre
"_id:string","acl:object","phoneNumber:string","Geopoint:geopoint|indexed"
"5311cd35e4b0fe98ca23990c","","375894739","[ 124.0 , -18.0]"
/pre
http://docs.appery.io/documentation/b...

RobertJay
Posts: 0
Joined: Fri Jun 15, 2012 1:32 pm

How to change the data type of a database column?

Igor, thank you - that's perfect. Have a nice day.

Return to “Issues”