Drupal Insert into new content type date only field from existing timestamp

CODE: 

INSERT INTO node__field_date (entity_id, bundle, revision_id, langcode, field_date_value) SELECT nid, type, vid, langcode, FROM_UNIXTIME(created, '%Y-%m-%d') FROM node_field_data 


Table comparison:

node__field_data = node__field_date

nid = entity_id

type = bundle

vid = revision_id

langcode = langcode

created = field_date_value


Sample data:

bundle:newsclips:type

entity_id:123670

revision_id:123785

langcode:en

field_date_value:2022-06-13




Comments

Post a Comment

Popular posts from this blog

Enable Theme Debug in Drupal 9

services.yml Navigate to  \sites\default create a the file sites/default/services.yml from sites/default/default.services.yml set the parameters as follows: parameters: twig.config: debug: true auto_reload: true cache: false settings.local.php  Navigate to / sites/ Make a copy of   example.settings.local.php   and rename it to   settings.local.php Locate the following lines and uncomment # $settings['cache']['bins']['render'] = 'cache.backend.null'; # $settings['cache']['bins']['page'] = 'cache.backend.null'; # $settings['cache']['bins']['dynamic_page_cache'] = 'cache.backend.null'; settings.php Navigate to  sites\default Open  settings.php  and search for ' local.php ' You should then find the following code block if (file_exists($app_root . '/' . $site_path . '/settings.local.php')) { include $app_root . '/' . $site_path . '/settings.local.php'; }
Read more

Remove drupal 9 extensions from database

Image
  drush eval "\$module_data = \Drupal::config('core.extension')->get('module'); unset(\$module_data['MODULE_NAME']); \Drupal::configFactory()->getEditable('core.extension')->set('module', \$module_data)->save();" If you get any more warning like below:  Then run this commands too: drush php - eval "\Drupal::keyValue('system.schema')->delete('my_already_removed_module');" drush php - eval "\Drupal::keyValue('system.schema')->delete('update_test_0');" Source:https://drupal.stackexchange.com/questions/72927/manually-disable-a-module Contribution from: https://eduvai.com
Read more

PHP redirect from http to https and www to non-www in Drupal 9

settings.php  Go to sites/default/settings.php add the following lines in the top of the file below <?php  if ( (! array_key_exists ( 'HTTPS' , $_SERVER )) && (PHP_SAPI !== 'cli' ) ) {   header ( 'HTTP/1.1 301 Moved Permanently' );   header ( 'Location: https://eduvai.com' . $_SERVER [ 'REQUEST_URI' ]);   exit (); } // Remove www if ( $_SERVER [ 'HTTP_HOST' ] == 'www.eduvai.com' ) {   header ( 'HTTP/1.0 301 Moved Permanently' );   header ( 'Location: https://eduvai.com' . $_SERVER [ 'REQUEST_URI' ]);   exit (); }
Read more